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:

[html]
mysql -p
[/html]

Then run the following:

[html]
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
[/html]

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.