error 1153 (08s01) got a packet bigger than 'max_allowed_packet'

It will be happen wile import database
you could specify max_allowed_packet if you your db has big

#mysql --max_allowed_packet=100m -u root -p database < dump.sql

or change my.cnf /my.ini file under mysqld section

max_allowed_packet=100M

or you could run following command in mysql console

mysql>set global net_buffer_length=1000000;
mysql>set global max_allowed_packet=1000000000;

now you get rid of that error

Post a Comment

0 Comments