Skip to content

Rate this page
Thanks for your feedback
Thank you! The feedback has been submitted.

Get free database assistance or contact our experts for personalized support.

Prepare an individual partitions backup

To prepare partial backups, follow a procedure similar to restoring individual tables. Apply the logs and use the --export option:

$ xtrabackup --prepare --export --target-dir=/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. During the prepare phase, xtrabackup removes entries for tables that were not included in the partial backup from the data dictionary, preventing future warnings or errors.

The next step is to restore the backup.