Where is the Mysql database on Mac OSX?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
mikebr
Forum Contributor
Posts: 243
Joined: Sat Sep 28, 2002 7:05 am

Where is the Mysql database on Mac OSX?

Post by mikebr »

I have a database set up on my desktop computer (Mac OSX) but want to move it onto my laptop (OSX) but can't seem to find any database or even know where to start to find it to copy it, it does exist but where?

Can anyone point me to how I make a copy of it and where it would be located?

Thanks
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post by twigletmac »

If you use phpMyAdmin it is relatively simple to take a copy of the database's tables and export them to another MySQL installation:
viewtopic.php?t=5899
or from the command line there's:
http://www.mysql.com/doc/en/mysqldump.html
and
http://www.mysql.com/doc/en/LOAD_DATA.html

Mac
redJag
Forum Newbie
Posts: 18
Joined: Fri Jan 31, 2003 12:17 am

Post by redJag »

/usr/local/mysql/data
Post Reply