| 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
(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:
This will reset the limitation to 100Mb for file insertion into blob type (or longblob) column. Then restart mysql server:
|
|||||||||||||
Last update: December 22nd, 2009 ••• Copyright © 2004-2010 ServerTune Inc.
