Comment 1 for bug 1008826

Revision history for this message
Alexey Kopytov (akopytov) wrote :

It is already possible to backup individual partitions with XtraBackup, since from the storage engines perspective partitions are regular tables with specially formatted names.

For example, table t containing partitions p0, p1 and p2 will be 3 separate tables inside InnoDB: t#P#p0, t#P#p1 and t#P#p2. So all that needs to be done to backup partition p0 (apart from enabling innodb_file_per_table) is to use t#P#p0 as a table 'name'.

We don't have that procedure documented anywhere explicitly, so I'm changing this bug to a doc request.