Question

database error code: max_allowed_packet

Posted March 2, 2015 2.3k views

error code:

1153 - Got a packet bigger than ‘maxallowedpacket’ bytes

my db size:1.8 gb normally
84 mb zip
setting:256M
you can help me please

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer

Hey there,

You would want to make sure that your /etc/my.cnf file included the line of max_allowed_packet=100M. You would want to restart MySQL and if you were importing a new database, you would also need to include a –max_allowed_packet flag.

Example:

  • mysql --max_allowed_packet=100M -uroot -p db_name < db_export.sql

Happy coding,

Jon Schwenn
Platform Support Specialist
DigitalOcean

Submit an Answer