follow these steps 1) first shutdown the database
mysqladmin shutdown 2) Start the mysqldeamon bin/safe_mysqld --max_allowd_packet=16M --user=mysql & 3) to check what max allowd_packet it is using mysqladmin variables in the out-put check the value of variable max_allowed_packet Anil DBA -----Original Message----- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 8:13 PM To: Ferino Mardo; [EMAIL PROTECTED] Subject: Re: max allowed packet error HI, > I have copied the mysql-medium.cnf to /etc/my.cnf and have noticed that > the "max-allowed-packet" is 1M. no matter what I set it to 8M, 10M, 16M > I still get the error. did you try this in your my.cnf in the [mysqld] section ? set-variable = max_allowed_packet=8M -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
