database error code: max_allowed_packet

March 2, 2015 497 views

error code:

1153 - Got a packet bigger than 'maxallowedpacket' bytes

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

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.


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

Happy coding,

Jon Schwenn
Platform Support Specialist

Have another answer? Share your knowledge.