Setup a Memcached-Enabled MAMP Sandbox Environment

Nate Haug wrote a great step by step tutorial "Setup a Memcached-Enabled MAMP Sandbox Environment" on the Lullabot site. Thank's Nate! Check it out!

For more information visit:

• memcached - a distributed memory object caching system

Setup a Memcached-Enabled MAMP Sandbox Environment

How to set the MySQL Default Storage Engine with MAMP

The MySQL Server of MAMP and MAMP PRO uses the Default Storage Engine MyISAM. If you want to change this, you have to change the config file f the MySQL Server. With this tutorial we want to show how to manage this. As Default Storage Engine we are using InnoDB.

MAMP:

1. Stop the MAMP Server if it is running.
2. Use a texteditor to create a file named "my.cnf" and save it to the "/Applications/MAMP/conf/" folder.
3. Add the following lines into the file:
   
   [mysqld]
   default-storage-engine = InnoDB
   
   
4. Save the file and close your editor.
5. Start the MAMP servers.

MAMP PRO:

1. Start MAMP PRO.
2. Stop the MAMP Server if it is running.
3. Select File -> Edit Template -> MySQL my.cnf
   
4. An editor window appears.
5. If a Warning message appears confirm with OK.
6. Find the section "[mysqld]"
7. Beneath the last line of this section add this line:
   
   default-storage-engine = InnoDB
   
   
8. The section "[mysqld]" now looks like this:
   
   
   
   
9. Save (Apple + S) all changes made on "my.cnf"
10. Close the editor window (Apple + W)
11. Start the MAMP PRO servers.

How-to check if the modifications succeeded. Servers of MAMP / MAMP PRO must be running.

• Open Terminal (Applications/Utilities)
• Enter the following line into the terminal and hit Enter:
  
  /Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot
  
  
• Enter the following line into the MySQL prompt and hit Enter:
  
  USE information_schema;
  
  
• Enter the following line into the MySQL prompt and hit Enter:
  
  SELECT * FROM engines;
  
  
• A table with the storage Engines of MySQL will show up. Inside the Support column "InnoDB" now has the value "DEFAULT". InnoDB now is the default Storage Engine of the MySQL Server.
  
  
• Enter the following line into the MySQL prompt and hit Enter:
  
  exit;

How to set the MySQL Default Storage Engine with MAMP

How to hide the MAMP icon from your dock

If you want to hide the MAMP or MAMP PRO icon from your dock after you opened the application you can follow this little tutorial.

Note:

• You'll need the Poperty List Editor which is part of the Mac OS X SDK and can be found in the directory "/Developer/applications Utilities/".
• You will loose all modifications after an update of MAMP or MAMP PRO.
• You want reach MAMP and MAMP PRO with Command + Tab any longer. Use Exposé instead.

MAMP:

1. Quit MAMP if it's running.
2. Open the directory "/Applications/MAMP".
3. Right click on Mamp.app
4. Choose "Show Package Contents".
5. A new window will pop up: "Contents"
6. Double click on Contents.
7. Open info.plist with the Property Editor
8. Add a new entry to the list - therefore choose either "Edit -> Add Item" or click on the "Add Item" icon
9. Enter "LSUIElement" (without quotes) into the "Key" column and hit Enter. Your entry will be changed into "Application is agent (UIElement)" automatically.
10. In the column "value" activate the checkbox.
    
    
11. Save and close the file.
12. Close "Property List Editor".

MAMP PRO:

1. Quit MAMP if it's running.
2. Open the directory "/Applications/MAMP PRO 1.8.4" (Version number may be different)
3. Right click on Mamp.app
4. Choose "Show Package Contents"
5. A new window will pop up: "Contents"
6. Double click on Contents.
7. Open info.plist with the Property Editor
8. Add a new entry to the list - therefore choose either "Edit -> Add Item" or click on the "Add Item" icon.
9. Enter "LSUIElement" (without quotes) into the "Key" column and hit Enter. Your entry will be changed into "Application is agent (UIElement)" automatically.
10. In the column "value" activate the checkbox.
    
    
11. Save and close the file.
12. Close "Property List Editor"

Now there is no MAMP or MAMP PRO icon in you dock anymore.

How to hide the MAMP icon from your dock

How to setup MAMP and Coda for Cubecart development

Ben Frain wrote a great step by step tutorial "How to setup MAMP and Coda for Cubecart development" in his blog. Thank's Ben! Check it out!

About Ben Frain
Ben Frain is a web designer and internationally published technology journalist based in the UK.

How to setup MAMP and Coda for Cubecart development

MY MAMP DUMP 0.3 released

We've just released a small update of MY MAMP DUMP. We've added a second Mac OS X Automator Workflow for importing SQL files into a database to the package.

You can download the new version from Sourceforge.
Download -> https://sourceforge.net/projects/my-mamp-dump/files/

MY MAMP DUMP 0.3 released

MY MAMP DUMP 0.2 released

We've just released a small update of MY MAMP DUMP.

Improvements

• MY MAMP DUMP now checks if MAMP and / or MAMP PRO is installed.

You can download the new version from Sourceforge.
Download -> https://sourceforge.net/projects/my-mamp-dump/files/

MY MAMP DUMP 0.2 released

MY MAMP DUMP released

We are often getting asked by our customers how to do dump big MySQL databases from MAMP or MAMP PRO. The problem is that phpMyAdmin is not really the right tool in most cases because of its PHP limits which are often leading to timeouts. Of course you could increase the limit inside the php.ini file. But mostly you won't do that because you don't wish to have too big differences between your MAMP server settings and the settings of your ISP.

Ok, you simply can do your dumps using the terminal - this is a fast an precise way but lots of users love the terminal as the devil the holy water.

So we thought about a solution which could be used by everyone and we decided to simply create an Automator workflow.

And now here we go: "MY MAMP DUMP" (download here)

• Requirements: min. Mac OS X 10.5 | min. MAMP/MAMP PRO 1.8
  (Mac OS X 10.6 Snow Leopard compatible)
• Platform: Universal Binary
• File type: Workflow / Application
• File size: 113.3 KB (Workflow) / 253.8 KB (Application)
• Translations: English

With this tiny tool (it's available as an open source workflow and as an application) you now can dump your MySQL databases from MAMP and MAMP PRO at ease. Choose the database(s) you plan to dump right from the list. Then choose the appropriate character set and the place where the dump should be saved. That's it!
We added MY MAMP DUMP as a free project to Sourceforge. The project is published under the GPL license. So if you want to expand or change the workflow just go ahead! Take a look at the MAMP Forum and at the bugbase where we added extra sections for this project.

Although it's not really beta MY MAMP DUMP is currently at an early development stage with the version number 0.1. We are looking forward to your feedback - just tell us your wishes, ideas and bug reports ;)

MY MAMP DUMP released