Skip to content

Instantly share code, notes, and snippets.

@RoesWibowo

RoesWibowo/fix.txt

Created March 15, 2017 06:16
Show Gist options
  • Save RoesWibowo/8e646b02be8ea6a3d47796373539d194 to your computer and use it in GitHub Desktop.
Save RoesWibowo/8e646b02be8ea6a3d47796373539d194 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL 1153 - Got a packet bigger than 'max_allowed_packet' bytes
Raw
fix.txt
mysql --max_allowed_packet=100M -u root -p database < dump.sql
Also, change the my.cnf or my.ini file under the mysqld section and set:
max_allowed_packet=100M
or command MySQL:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment