Got packet bigger than ‘max_allowed_packet’ bytes when dumping table

This article is for Zmanda Recovery Manager For MySQL (ZRM) 

Error Message

Logical backup fails with message:

Got packet bigger than 'max_allowed_packet' bytes when dumping table

Error Description

The ZRM for MySQL runs the mysqldump command as part of logical backup with the default max_allowed_packet of 1GB. If the packets are larger than 1G, the backup fails with the message.

Solution

Edit the Logical Backup Options field on the Backup|how page  to modify the max_allowed_packet  parameter.

For instance, to change max_allowed_packet to 2GB, enter –max_allowed_packet=2G on the Logical Backup Options, and click the Save button.

Powered by BetterDocs

Leave a Reply