Mac OS X mySQL database user path (MAMP PRO)

Question

I am using MAMP (OS-X 10.6.6) and I want to move my mybQL folder to the Dropbox folder. MySQL MAMP server runs its databases in

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

.. and I cannot get it to follow symbolic links or aliases in the mysql folder.

Is there a way to change the path used by mySQL to store its databases? At the MAMP forum, they say that this is not possible, but I believe that there should be some kind of configuration file for any mySQL server running MAMP, which can be changed to indicate an alternative location for the databases used ..?

Does anyone know how to achieve this? Storing the database on Dropbox is the last element that I need to decide in order to work with my projects from different computers.

Answer 1

I just realized that its just a "pseudonym" of the seeker who will not work. creating the proper unix symlink works great. therefore, it solves the problem and saves the databases in Dropbox.

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

Answer 2

The mwb method works. Remember that you must also have an Apache / MySQL server as a user. These settings are specified in MAMP PRO (Server → General)

If you intend to use dropbox to access the database on another computer, you will also need the same paths to Dropbox.