Buy Percona ServicesBuy Now!

Restoring the Backup

Because xtrabackup doesn’t copy MyISAM files, .frm files, and the rest of the database, you might need to back those up separately. To restore the InnoDB data, simply do something like the following after preparing:

cd /data/backups/mysql/
rsync -rvt --exclude 'xtrabackup_checkpoints' --exclude 'xtrabackup_logfile' \
   ./ /var/lib/mysql
chown -R mysql:mysql /var/lib/mysql/

Previous topic

Making an Incremental Backup

Next topic

How to setup a slave for replication in 6 simple steps with Xtrabackup

Visit Percona Store

General Inquiries

For general inquiries, please send us your question and someone will contact you.