Tips for upgrading MAMP
A few days ago I needed to upgrade my local install of MAMP, the application that installs Apache, MySQL, and PHP locally on your Macintosh for testing purposes, and I hit a bit of a snag. I accidentally deleted all of my databases!
Being on Leopard, and having setup Time Machine the moment I upgraded to the new Mac OS, meant that I didn’t have much to worry about. I clicked on Time Machine, and restored the version of MAMP I had installed less than an hour before upgrading. Quick, simple, and a heckuva time saver.
So I had to figure out how to upgrade MAMP without losing any of my testing databases, their structure, or the data therein. So here is a quick and dirty list of tips for upgrading MAMP that you might find useful.
- Stop the Apache and MySQL services via MAMP.
- Quit the application.
- Copy the /Applications/MAMP/db/mysql/ directory to your desktop*.
- Upgrade MAMP per the included instructions.
- Drop the copied MySQL directory back into /Applications/MAMP/db/mysql/.
- Restart MAMP and the Apache and MySQL services.
This worked for me, your mileage may vary. I also tried to export all of the data via PHPMyAdmin though I wouldn’t recommend that method since this seems so much easier. Anyone have any tips to add?
* If you are using SQLLite you will want to copy that directory as well.
Related sites
Recent features
Coheed and Cambria - The Velorium Camper II: Backend Of Forever
Leah Andreone - Break Your Fall
The Format - Give It Up
Song of the week
Sara Bareilles - Between the Lines
Sara Bareilles' "Between the Lines" is the Song of the Week for April 20 to 26.
Warning: main(images/faq.php) [function.main]: failed to open stream: No such file or directory in /home/.eastwood/cdevroe/theubergeeks.net/wp-content/themes/clockworkorange/sidebar.php on line 119
Warning: main(images/faq.php) [function.main]: failed to open stream: No such file or directory in /home/.eastwood/cdevroe/theubergeeks.net/wp-content/themes/clockworkorange/sidebar.php on line 119
Warning: main() [function.include]: Failed opening 'images/faq.php' for inclusion (include_path='.:/usr/local/lib/php') in /home/.eastwood/cdevroe/theubergeeks.net/wp-content/themes/clockworkorange/sidebar.php on line 119
Warning: Missing argument 2 for httprequest() in /home/.eastwood/cdevroe/theubergeeks.net/wp-content/plugins/gravatars2.php on line 320
Warning: Missing argument 2 for httprequest() in /home/.eastwood/cdevroe/theubergeeks.net/wp-content/plugins/gravatars2.php on line 320
Great tip. I do have one question. If you replace the MySQL directory do you also lose the version upgrade of MySQL that is built in with MAMP?
michael on December 30th, 2007 1:41 pm
michael: Good question. It appears that the actual mysql service is kept elsewhere in the package - so - my version of MySQL was indeed upgraded.
Colin Devroe on December 30th, 2007 2:48 pm