Mac OS X mySQL custom database path (MAMP PRO)

mysql macos mamp mysql-management
mikkelbreum picture mikkelbreum · Jan 20, 2011 · Viewed 10.5k times · Source

I'm using MAMP (OS-X 10.6.6) and I want to move my mySQL db folder to my dropbox folder. The MySQL server MAMP runs stores its databases in

/Library/Application Support/appsolute/MAMP PRO/db/mysql

..and I can't get it to follow symlinks or aliases to the mysql folder.

Is there a way to change the path mySQL uses for storing its databases? On the MAMP forum they say it's not possible, but I imagine there must be some kind of config file for whatever mySQL server it is that MAMP is running that can be changed to specify an alternative location for the used DBs..?

Anyone know how to acheive this? Storing the DB's on dropbox is the last element I need to solve to be able to work on my projects from my different computers.

Answer

mikkelbreum picture mikkelbreum · Jan 20, 2011

Just realized that its just the finder 'alias' type that won't work. creating a proper unix symlink works fine. so doing this solves the problem and keeps the databases on dropbox.

ln -s /Users/username/Dropbox/MAMP_db/mysql /Library/Application\ Support/appsolute/MAMP\ PRO/db/mysql

Related questions

CakePHP Database connection "Mysql" is missing, or could not be created

There have been several other posts about this, but none of the answers seemed to work for me. When I navigate to the CakePHP page on my local machine, there is one error: Cake is NOT able to connect to …

Read More
Restoring deleted 'root' user and password for MySQL

I accidentally deleted the root user on my local dev setup of MAMP/MySQL running on OS X. There are no other users created to get back into MySQL. This is a mild nightmare can't seem to do anything without …

Read More
MySQL with MAMP does not work with OSX Yosemite 10.10

[EDIT] The last version of MAMP with the last version of OSX Yosemite works fine. I installed the beta of Yosemite two month ago, no problem with MAMP. With the last release of OSX, Apache and MySQL did not work. …

Read More