Got a Packet Bigger than ‘max_allowed_packet’ bytes

Trying to import a large SQL backup I encountered this error.

“Got a packet bigger than ‘max_allowed_packet’ bytes”

The fix is to increase the MySQL daemon’s max_allowed_packet. You can do this to a running daemon by logging in as Super and running the following commands. Keeping the session open create a 2nd session in which to run the import.

The (mt) dv mysql root username is `admin` and the password is the cpanel/plesk password.

# mysql -u admin -p

mysql> set global net_buffer_length=1000000;
Query OK, 0 rows affected (0.00 sec)

mysql> set global max_allowed_packet=1000000000;
Query OK, 0 rows affected (0.00 sec)

Leave a Reply

Your email address will not be published. Required fields are marked *