Problem Description
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
Apparently there are 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.
[1]: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
AI-Generated Solution
Powered by LMSouq AI · GPT-4.1-mini
Analyzing problem and generating solution…
Was this solution helpful?