ERROR 1153 (08S01) at line 16174: Got a packet bigger than ‘max_allowed_packet’ bytes

mysql

As I was importing a MySQL database, I got the following error.

ERROR 1153 (08S01) at line 16174: Got a packet bigger than ‘max_allowed_packet’ bytes

This can be quickly resolved when importing form the command line. During the import, I included “–max_allowed_packet”.

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

Leave a Reply

Your email address will not be published. Required fields are marked *