SBDavid
Apr 28th, 2010
Apr 28th, 2010
Got a packet bigger than ‘max_allowed_packet’ bytes
Got a packet bigger than ‘max_allowed_packet’ bytes
If you get this error when trying to dump a MySQL DB, this is due to the packet limit of MySQL server.
To solve this issue, add an extra entry into /etc/my.cnf file under [mysqld] group:
max_allowed_packet = 100M
This will reset the limitation to 100Mb for file insertion into blob type (or longblob) column. Then restart mysql server:
/sbin/service mysql restart
Reference:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_allowed_packet
