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/

Success criteria

• The exit status of xtrabackup is 0.

Notes

• You might want to set the xtrabackup --use-memory option 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

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 consulting services , contact Percona Sales.

---

Last update: 2023-03-13