Author Topic: mysql: Got a packet bigger than 'max_allowed_packet' bytes  (Read 7804 times)

Offline admin

  • Administrator
  • Sr. Member
  • *****
  • Posts: 296
    • View Profile
If you got this error:
Code: [Select]
Got a packet bigger than 'max_allowed_packet' bytesThis means you need to increase the max_allowed_packet. You can do that by changing the my.cnf or my.ini file under the mysqld section and set max_allowed_packet=100M or you could run these commands in a mysql console connected to that same server:

Code: [Select]
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

(Use a very large value for the packet size.)