Got packet bigger than ‘max_allowed_packet’ bytes when dumping table

You may get the error mentioned as the post heading while you backup using some automatic backup tools such as MySQL ZRM or mysqldump.Sometimes you will see that the even though adding the

max_allowed_packet='N'

entry in the MySQL server my.cnf file. The reason behind this is, you have to add the ‘max_allowed_packet’ entry in the client side as well. The default value for ‘max_allowed_packet’ at server is 1M and at the client is 16MB. The largest value for ‘max_allowed_packet’ value at client or server is 1G. Add the value appropriate for your situation and your backup should work well.

Enjoy 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s