Archive for the 'mysql' Category

Max allowed packet problem with MAMP

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!”