Making a Full Backup¶
Backup the InnoDB data and log files - located in/var/lib/mysql/
- to/data/backups/mysql/
(destination). Then, prepare the backup files to be ready to restore or use (make the data files consistent).
Make a backup:¶
xtrabackup --backup --target-dir=/data/backups/mysql/
Prepare the backup twice:¶
xtrabackup --prepare --target-dir=/data/backups/mysql/
xtrabackup --prepare --target-dir=/data/backups/mysql/
Success Criterion¶
- The exit status of xtrabackup is 0.
- In the second
--prepare
step, you should see InnoDB print messages similar toLog file ./ib_logfile0 did not exist: new to be created
, followed by a line indicating the log file was created (creating new logs is the purpose of the second preparation).
Contact Us
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 professional services, contact Percona Sales.