Friday, March 16, 2012

MySQL Error: Got a packet bigger than 'max_allowed_packet' bytes

Command:
mysql -u root -ppassw db_name < db.sql

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

FIX/SOLUTION:
1) Edit db.sql and add:
set global net_buffer_length=1000000;
set global max_allowed_packet=100000000;

2) Run:
mysql --max_allowed_packet=100000000 -u root -ppassw db_name < db.sql

No comments: