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
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:
Post a Comment