Archive for the tag 'bigger'

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