MySQL Forums
Forum List  »  Backup

max_allowed_packet and its impact on backup (and replication)
Posted by: Timo Schoeler
Date: July 05, 2011 06:06AM


I have a bunch of Master/Slave MySQL setups running. Recently I ran into this error message when dumping databases for backup purposes:

mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `etkgjg` at row: 8071

I have set max_allowed_packet to 1073740800 (maximum possible), so I'm not able to dump objects contained in the database which are bigger than this maximum (of about 1GiByte). That makes backup of these objects via mysqldump impossible, I guess.

I furthermore presume that replication is also affected by this? I.e., I have a 2GiByte BLOB on the Master, which, due to this limitation, is not being replicated?

Thanks & best regards,


Options: ReplyQuote

Written By
max_allowed_packet and its impact on backup (and replication)
July 05, 2011 06:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.