i was migratin a database in my linux centos server when i received this error:

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

to fix it, just edit the my.cnf file with these command. i have a centos linux server so this is how i did it

nano /etc/my.cnf


look for max_allowed_packet if you cant find it add to look like this
max_allowed_packet=500M

NOTE. be sure to put it just under [mysqld] section

now you can restart your mysql server:
/etc/init.d/mysqld restart


if you still get the error, try increasing to higher number, look at the file you are importing to determine how much more you will need