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

    al404

    Joined:
    Apr 24, 2011
    Location:
    Novara, Italy
    #1
    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

    Joined:
    Oct 17, 2012
    #2
    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

    superscape

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

    https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

    ...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

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

    Joined:
    May 7, 2014
    #5
    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

    Joined:
    Aug 21, 2011
    Location:
    Stockholm Sweden
    #6
    SQlite ?

    Possibly.
    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