CODEWITHSUNDEEP
mysqlmacosdropbox
Jason
Jason

Reputation: 219

Where is the MySql table data stored (Mac)?

I am working on syncing my MySql database on two computers (using dropbox with symlinks). The current database information is stored here: /usr/local/mysql/data

When syncing the db, only the database displays along with the table names, but the data does not display. Is there another place that data is stored?

Upvotes: 4

Views: 8488

Answers (1)

Juan
Juan

Reputation: 483

well... if you type

show variables where Variable_name ='datadir';

you will see something like

+---------------+---------------+
| Variable_name | Value         |
+---------------+---------------+
| datadir       | /path/to/data |
+---------------+---------------+

But to access them manually, you'll need administrator privileges

Upvotes: 25

Related Questions