#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
Login to mysql and run the below command:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
One thought on “#1153 – Got a packet bigger than ‘max_allowed_packet’ bytes”
Leave a Reply
You must be logged in to post a comment.
So, open a terminal, type mysql to get a mysql prompt, and issue these commands:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
Keep the mysql prompt open, and run your command-line SQL execution on a second terminal..