MySQL Forums
Forum List  »  Backup

Re: Help on backing up parititions
Posted by: Rick James
Date: April 10, 2013 08:58PM

Percona's XtraBackup is probably too aimed at full backups to be of use. I don't happen to know of another Percona tool for backing up one partition.

mysqldump can be told to do a particular WHERE clause; you would design the WHERE to hit exactly all of the one partition you are dumping. This would probably have to be done in non-SQL code, since there is no way to launch mysqldump from an EVENT (etc).

Options: ReplyQuote

Written By
April 05, 2013 04:21AM
April 08, 2013 10:31AM
April 09, 2013 10:20PM
Re: Help on backing up parititions
April 10, 2013 08:58PM
April 13, 2013 08:10AM

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.