If you get this error when trying to dump a MySQL DB, this is due to the packet limit of MySQL server (more details from MySQL documentation at: http://dev.mysql.com/doc/mysql/en/packet -too-large.html . 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

Other articles in this Category

I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?

Starting MySQLCouldn't find MySQL manager or server

How can I check if query cache is working on my MySQL server?

HowTo :: commands, statements, and clauses

HowTo :: change MySQL root password

MySQL :: HowTo fix Access-Denied Errors

Warning: MySQL server has gone away

Error :: Can't connect to [local] MySQL server

Who is exhausting MySQL resources on my server?

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES