Mysql error: received a packet whose size exceeds max_allowed_packet bytes.

Question

to import mysql database give me this error:

$ `mysql -u user -p password zxc_db < zxc.sql` ERROR 1153 (08S01) at line 96: Got a packet bigger than 'max_allowed_packet' bytes 

Please give me the best solution to solve it? tanx.

Answer 1

the best solution is "change mysql.cnf" debian: /etc/mysql/mysql.cnf change this line ==> max_allowed_packet = 16M to: max_allowed_packet = 128M

or add --max_allowed_packet = 128M to your mysqldump command.

 mysql --max_allowed_packet=128M -u user -ppass database < database.sql