Question

database error code: max_allowed_packet

Posted March 2, 2015 2.8k 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

Add a comment
merpervahap
By:
merpervahap

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.

×
Submit an Answer
1 answer
jschwenn February 15, 2016

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

Reply Report

Looking for something else?

Ask a new question Search for more help