MySQL ERROR 1153: Got a packet bigger than ‘max_allowed_packet’ bytes

Posted by admin
July 2, 2009

Default packet settings can be problematic when you’re doing backups/restores of large DBs.

To overcome this issue, just set larger buffers by running these SQL statements in your normal SQL window:

set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;

Bookmark and Share
MySQL

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.

Comments

No comments yet.

Leave a comment

(required)

(required)