#1153 – Got a packet bigger than “max_allowed_packet’ bytes
by Linuxfiled in
I got an error saying “#1153 – Got a packet bigger than “max_allowed_packet’ bytes” while uploading larger than 1M sql dump file. I found that by default configuration max_allowed_packet is 1M. You need to increase the value for from 1M to whatever you want like 32M.
Login to mysql on your server.
#mysql -u root -p
Add max_allowed_packet=32M under [mysqld] section
max_allowed_packet=32M #Added line
Save the file.
Esc w Enter or Esc x Enter
Restart the mysqld server
#service restart mysqld