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

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

Sep 19 '08

722

You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import.

For the client, you can specify it on the command line:

mysql --max_allowed_packet=100M -u root -p database < dump.sql

Also, change the…

Open Full Answer