Holy crud – that took a while to figure out. I was trying to work locally on a project, and kept running into the “max_allowed_packets” error when importing the database (I was using PHPMyAdmin, but this comes up elsewhere too). I knew that the default was 1M, but I had a hard time figuring out where to change this number.
It took me a while and a lot of attempts at difference solutions to find the answer – presented to me in a forum. The key is to replicate the original MySQL conf file (which MAMP apparently removes) with a larger max.
Quoted below (from “weotch”) in case the link ever rots, but here is the original:
“Ok, I think I found my answer. I copied
/Applications/MAMP/Library/share/mysql/my-small.cnf to
/Applications/MAMP/db/mysql/my.cnf (notice that I renamed it). Then I
tweaked the settings I needed to in it and restarted MAMP. Golden!”
You rock. Thanks so much for posting this.
You are the bomb – thanks!
Thank you! thank you
thank you
for the win
thanx for the pointer.
However the location of /Applications/MAMP/db/mysql/my.cnf has been deprecated you may be better off moving fw to make the my.cnf file in /Applications/MAMP/Library/my.cnf
Thanks for the hint. Good work.