Restoring the Backup¶
xtrabackup does not 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/
For free technical help, visit the Percona Community Forum.
To report bugs or submit feature requests, open a JIRA ticket.
For paid support and managed or consulting services , contact Percona Sales.
Last update: 2022-11-10