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).
Subject
Views
Written By
Posted
2443
April 05, 2013 04:21AM
1227
April 08, 2013 10:31AM
1095
April 09, 2013 10:20PM
Re: Help on backing up parititions
1157
April 10, 2013 08:58PM
1177
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.