Developers Heaven Forum

DataBase => MySQL => Topic started by: admin on May 12, 2011, 01:40:22 AM

Title: mysql: Got a packet bigger than 'max_allowed_packet' bytes
Post by: admin on May 12, 2011, 01:40:22 AM

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.)