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: 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