Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have just updated my MacBook to Mountain Lion. Since then, my MAMP installation does not work properly so I decided to use the build httpd/php stuff. For this, I have additionally installed a new mysql server (following this tutorial). Everything runs very well. Now my question is, how to use my old databases in my new server? I tried to create a new database which creates a folder "databasename". Into this folder I moved all the .frm files, corrected rights and owner and started mysql, but unfortunately, phpmyadmin does not recognize the tables... did I something wrong? Alternatively, I would just set the data directory of the new mysql server to my old directory, but I cannot find the my.cnf file :-( Where is it stored?

share|improve this question
up vote 1 down vote accepted

The best thing to do is to export the databases from the MAMP server and import them to your new database server.

Here's a guide with MySQL dump and restore:

share|improve this answer

Your Answer


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.