Ok, here’s one you don’t see every day.
Importing a mysql dumpfile results in “ERROR 1153 (08S01) at line 265: Got a packet bigger than ‘max_allowed_packet’ bytes”
Log in to a mysql console,
enter the magic commands:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
Modify your import to include the command:
so you have something like
mysql –max_allowed_packet=100M -u user -p db_name < dump.sql
Your mileage may vary ( do they say kilometerage elsewhere?) so increase the allowed sizes if you have to.