MySQL Error: Got a packet bigger than ‘max_allowed_packet’ bytes

When trying to import large SQL dump, you often get the above message. Remedy for this issue is to increase the packet size of MySQL's daemon by setting a packet size of max_allowed_packet. Sudo to your account and set the following root $ mysql -u admin -p mysql> set global net_buffer_length=1000000; mysql> set global max_allowed_packet=1000000000; In the command line, issue the command $ mysql --max_allowed_packet=128M -uUSER -pPASSWORD database < database.sql.dump