Thursday, December 1, 2011

MYSQL Packet too large

go to /etc/my.cnf

If you are using MySQL 4.0 or newer, enter:

[mysqld]
# Allow packets up to 16M (change its value)
max_allowed_packet=16M

If you are using an older version of MySQL, enter:
[mysqld]
# Allow packets up to 16M
set-variable = max_allowed_packet=16M


To store 8 MB objects (default is 16M).

0 comments:

Post a Comment