Tuesday, February 23, 2010

ERROR 1153 (08S01) at line *: Got a packet bigger than 'max_allowed_packet' bytes

ERROR 1153 (08S01) at line 19747092: Got a packet bigger than 'max_allowed_packet' bytes

increase max_allowed_packet value in my.cnf

mysql>set global max_allowed_packet=100M;

provide max_allowed_packet value at command prompt while restoring database

mysql -u -p database_name --max_allowed_packet=1073741824 < backup.sql


increase --net_buffer_length value for database restore on network.

mysql -u -p database_name --max_allowed_packet=1073741824 --net_buffer_length=100M < backup.sql

The maximum value for --max_allowed_packet is 1G ( 1073741824 )

issue resolved.