MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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

Hi,

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,

Timo

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
max_allowed_packet and its impact on backup (and replication)
5191
Timo Schoeler
July 05, 2011 06:06AM
Re: max_allowed_packet and its impact on backup (and replication)
1649
Rick James
July 06, 2011 09:13AM


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.