Where does Leopard Server's MySQL store its data?

mysql macos osx-leopard
pixelcort picture pixelcort · Jan 15, 2009 · Viewed 8.7k times · Source

I'm trying to recover a table in a MySQL database from Time Machine, however I don't know and can't find where Leopard Server's MySQL stores its data files.

  1. Does anyone know where they are stored?
  2. Is there an easy way to run mysqldump on them without restoring them?
  3. Is there anything else I should know about Time Machine and MySQL data file(s)?

Answer

MarkR picture MarkR · Jan 15, 2009

Connect to the database and issue

SHOW VARIABLES LIKE 'datadir';

Which will tell you the right answer even if it's been changed from the default.

Related questions

Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed these commands: $ …

Read More
How to stop mysqld

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get the following output, which allows me to start mysql server. /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=... …

Read More
start MySQL server from command line on Mac OS Lion

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I want to know the instruction to start from command-line. I do as follow: After su root I start the mySQL …

Read More