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

Mysql Tips for Beginners * How to log into Mysql from command prompt? First, Go to the Mysql installation directory and move to the bin directory (C:\Mysql\bin\) Execute the following command to log into Mysql C:\Mysql\bin> mysql -u [username] -p [password] You will be shown mysql command which indicates that you have successfully logged in mysql> _ (more…)