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.


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.

fr_FRFrench it_ITItalian es_ESSpanish de_DEGerman pt_BRPortuguese sv_SESwedish tr_TRTurkish nl_NLDutch jaJapanese pl_PLPolish zh_TWChinese id_IDIndonesian ko_KRKorean ms_MYMalay thThai en_USEnglish