How-To: Create my.cnf file in MAMP
Nov.25, 2009 in
Development
This is a simple process, however not something I could find documented anywhere easy to find. MAMP supplies you with a range of sample configuration files:
/Applications/MAMP/Library/share/mysql/my-huge.cnf /Applications/MAMP/Library/share/mysql/my-innodb-heavy-4G.cnf /Applications/MAMP/Library/share/mysql/my-large.cnf /Applications/MAMP/Library/share/mysql/my-medium.cnf /Applications/MAMP/Library/share/mysql/my-small.cnf
To setup one of these for MAMP, simply issue the following command:
sudo cp /Applications/MAMP/Library/share/mysql/my-choicehere.cnf /Applications/MAMP/Library/my.cnf
December 2nd, 2009 at 2:57 am
Nice tip but what are those different config files for ? Do they provide any extra features or hidden options or something ?
January 25th, 2010 at 6:21 am
Hi, thanks for this tip. But it isn’t working for me. If I put a file as my.cnf in the required folder and start the server again – I loose all the Innodb variables (controlled by phpmyadmin) and can no longer work with my existing innodb tables. And thats what I need. If I kill the copied my.cnf file and restart the server the innodb variables are there again. But I’d like to change them. Anny suggestions ?