Re: Strange error: Got a packet bigger than 'max_allowed_packet' bytes
On May 14, 2:32 am, subtenante <zzsubtenant...@gmail.com> wrote:
> On 13 May 2007 14:23:06 -0700, "laredotorn...@zipmail.com"
>
> <laredotorn...@zipmail.com> wrote:
>
> In your MySQL installation folder, you may have a my.ini file.
> Add something like somewhere inside off it :
>
> max_allowed_packet=16M
>
> and restart your server.
I added this to /etc/my.cnf in two places (see below) but to no
avail. I still get the error.
[mysqld]
datadir=/var/lib/mysql
socket=/tmp/mysql5.sock
# Default to using old password format for compatibility with mysql
3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
max_allowed_packet=32M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/tmp/mysql5.sock
max_allowed_packet=32M
- Dave
|