[MySQL] ERROR 1553 (08S01) at line xxxxx: Got a packet bigger than 'max_allowed_packet' bytes

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

 

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000

 

http://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes