Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

As I would like to move those files from one server to another server, while the database is offline.

share|improve this question

4 Answers 4

up vote 4 down vote accepted

It should be stored in: /usr/local/mysql/data

share|improve this answer

I don't have access to my Mac right now, so can't say for certain. Why not simply search (from Terminal, not Spotlight) the file system for "mysql", as there will always be a table named mysql.

share|improve this answer

Look for the my.cnf file - should be in the /etc/ directory and then look for a line like:

datadir=/var/lib/mysql

The datadir is where mysql stores all the database files.

Autobyte

share|improve this answer

OS X Server (at least v10.6) keeps the database in /var/mysql by default. You can change this in Server Admin -> MySQL service -> Settings -> Database location (note that editing this field doesn't actually move the data, just changes where it's loaded from).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.