DataBase > MySQL

mysql: Got a packet bigger than 'max_allowed_packet' bytes

(1/1)

admin:
If you got this error:

--- Code: ---Got a packet bigger than 'max_allowed_packet' bytes
--- End code ---
This 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: ---set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
--- End code ---

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

Navigation

[0] Message Index