This article is for Zmanda Recovery Manager For MySQL (ZRM)
Logical backup fails with message:
Got packet bigger than 'max_allowed_packet' bytes when dumping table
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.
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.