MySQL database file on Mac OS

Question

A really dumb question. I have used MySQL workbench created a new database/schema (on the same local Mac OS box), and wondering what are path of the database physical folder, which it stores data/index files?

BTW, I did search by database name, but cannot find anything. :(

thanks in advance, Lin

issue a `show variables where variable_name='datadir';` then follow up with scrutiny of folder underneath it — Drew, Nov 12 '15 at 03:20
@Drew, thanks for answering my question. Could you add as an answer so that I can mark it as Answer to benefit other people in the future? Thanks. — Lin Ma, Nov 12 '15 at 03:33

score 2 · Accepted Answer · edited May 23 '17 at 11:51

Ok, either issue a show variables where variable_name='datadir'; then follow up with scrutiny of folders underneath it. Folders are the schema/db folders.

Or look at the answer Here on the Stack pointing one to examining the /etc/my.cnf file that may contain:

[mysqld]
datadir=/var/lib/mysql

on my Windows box they would appear as

C:\ProgramData\MySQL\MySQL Server 5.6\data>dir /ad

 Directory of C:\ProgramData\MySQL\MySQL Server 5.6\data

09/13/2015  01:36 PM    <DIR>          ajax_stuff
07/14/2015  09:52 PM    <DIR>          mysql
...
11/11/2015  10:37 PM    <DIR>          so_gibberish
09/21/2015  01:10 PM    <DIR>          real_secret_stuff

Sorry, not on my mac at the moment

Thanks @Drew for all the help. Have a good day. :) – Lin Ma Nov 12 '15 at 03:57 — Lin Ma, Nov 12 '15 at 03:57

MySQL database file on Mac OS

1 Answers1