max_allowed_packet problem
Hi;
I'm running into this error:
Got a packet bigger than 'max_allowed_packet' bytes
I've tried the following:
from the shell running:
mysql --max_allowed_packet=32M -u root -p // because it requires I log in
editing /etc/my.cnf to include:
max_allowed_packet = 50M
and editing /usr/bin/mysqld_safe to include:
ulimit -d 256000
and restarting mysql several times. I'm running CentOS recent vintage with Python 2.6 calling mysql through MySQLdb. The longblob I'm trying to upload is 1.35M. Please advise.
Thanks,
Dave
Subject
Written By
Posted
max_allowed_packet problem
July 17, 2011 11:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.