Make 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:¶
$ xtrabackup --prepare --target-dir=/data/backups/mysql/
- The exit status of xtrabackup is 0.
You might want to set the
xtrabackup --use-memoryoption to something similar to the size of your buffer pool, if you are on a dedicated server that has enough free memory. More details here.
For a more detailed explanation, see Creating a backup
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: 2023-03-13