Hi, I'm importing a mysql dump and getting the following error:
$ mysql foo < foo.sql
ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes
The dump is a mysqldump of a FogBugz database. it's FogBugz 6.1.33, Unix.
Apparently FogBugz stores attachments in the database, which makes for very large inserts.
This is on my local machine, a Mac with MySQL 5 installed from the MySQL package.
Where do I change max_allowed_packet to be able to import the dump?
Is there anything else I should set?
Just running mysql --max_allowed_packet=32M …
resulted in the same error.