LMSouq
database Open

MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

KC
kch
1 month ago
3 views
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

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base