macOS easy way to share a mysql DB with a mac user

[al404]

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

 

[blackboxideas]

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.

 

[superscape]

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! ;-)

 

[ahall52]

Is your database currently accessible online or is it local on your development machine?

 

[typonaut]

Give them a MySQL dump, or if they can access your server let them have access with a client like Navicat.

 

[ghellquist]

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