Documentation :: Error: 1153 Got a Packet bigger than 'max allowed packet' bytes

When importing a large SQL file that was originally created with Sequel Pro, I received the following error a few minutes into the import.

ERROR 1153 (08S01) at line 2202495: Got a packet bigger than 'max_allowed_packet' bytes

By updating the system variable max_allowed_packet from 1048576 to 1048575000 bytes I was able to get the SQL import to function as expected.

set max_allowed_packet=1048576000;

I also updated the system variable net_buffer_length from 16384 to 1000000 by running the following command:

set net_buffer_length=1000000;

To check that the system variables are set, run either of the following commands:

select @@max_allowed_packet;

select @@net_buffer_length;