EmergencyEMERGENCY? Get 24/7 Help 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 Percona Xtrabackup



General Inquiries

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