easy way to share a mysql DB with a mac user

Discussion in 'Mac Programming' started by al404, May 6, 2015.

  1. al404 macrumors 6502


    Apr 24, 2011
    Novara, Italy
    is not really a programming question but i guess here i can find somebody that can have an answer

    i'm developing a web application based on mysql DB and a often need to share my tables with a non technical person that uses a MAC and need to analyze data inside tables

    at this moment i just export as CVS as sharing file format

    i was wondering is there is an easy way to share a DB like an access file for some software that can be for mac only

    what i need to do is to export my tables to that DB and send it as standalone file

    so exporting should be an easy and fast task
  2. blackboxideas macrumors member

    Oct 17, 2012
    Could you set up a mySQL database on a host they can access?

    sequelpro is a pretty easy to look at / understand interface, they could install that and use the remote host you'd set up to view the data.
  3. superscape macrumors 6502a


    Feb 12, 2008
    East Riding of Yorkshire, UK
    Can't you just do a mysqldump and give the other user that?


    ...or you can do the same thing through Sequel Pro as blackboxideas suggests. An alternative might be to just give the user read only access to your database if they just need to run a few queries to analyse what's there?

    Also, if you go the Sequel Pro route, you can dump the data to CSV if you really must! ;-)
  4. ahall52 macrumors newbie

    Feb 3, 2013
    Is your database currently accessible online or is it local on your development machine?
  5. typonaut macrumors member

    May 7, 2014
    Give them a MySQL dump, or if they can access your server let them have access with a client like Navicat.
  6. ghellquist macrumors regular

    Aug 21, 2011
    Stockholm Sweden
    SQlite ?

    You could dump the database to SQLite. SQLite databases comes as a single file and is easy to transport to other machines. It is also built-in to Mac OS as well as IOS. (Started with sqlite3 command).
    // Gunnar

Share This Page