MySQL ERROR 1153: Got a packet bigger than ‘max_allowed_packet’ bytes
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;
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