"Got a packet bigger than 'max_allowed_packet' bytes" MySQL error

Tech Notes

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) http://stackoverflow.com/questions/93128/mysql-got-a-packet-bigger-than-maxallowedpacket-bytes http://kb.mediatemple.net/questions/1070/What+is+the+root+username+for+MySQL%3F