ServerTune

Browse by category

Search    |    Advanced search

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:

max_allowed_packet = 100M

This will reset the limitation to 100Mb for file insertion into blob type (or longblob) column. Then restart mysql server:

 
 
Add comment
 
Views: 1039
 
Votes: 0
 
Comments: 0
 

Other articles in this Category

RSS