When trying to insert a database I got the following error:

“ERROR 1153 (08S01) at line 69: Got a packet bigger than ‘max_allowed_packet’ bytes”

This is due to the database being too large. To fix:

Enter MySQL:

mysql -p

Then run the following:

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

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@matthewc424.sg-host.com.