Skip to content

Prepare an individual partitions backup

For preparing partial backups, the procedure is analogous to restoring individual tables. Apply the logs and use xtrabackup --export:

$ xtrabackup --apply-log --export /mnt/backup/2012-08-28_10-29-09

You may see warnings in the output about tables that do not exist. This happens because InnoDB-based engines stores its data dictionary inside the tablespace files. xtrabackup removes the missing tables (those that haven’t been selected in the partial backup) from the data dictionary in order to avoid future warnings or errors.

Next step

Restore the partition from the backup

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.

Last update: 2024-06-12