The xtrabackup Binary

The xtrabackup binary is a compiled C program that is linked with the InnoDB libraries and the standard MySQL client libraries. The InnoDB libraries provide functionality necessary to apply a log to data files, and the MySQL client libraries provide command-line option parsing, configuration file parsing, and so on to give the binary a familiar look and feel.

The tool runs in either xtrabackup --backup or xtrabackup --prepare mode, corresponding to the two main functions it performs. There are several variations on these functions to accomplish different tasks, and there are two less commonly used modes, xtrabackup --stats and xtrabackup --print-param.

Other Types of Backups

• Incremental Backups

• Partial Backups

Advanced Features

• Throttling Backups

• Scripting Backups With xtrabackup

• Analyzing Table Statistics

• Working with Binary Logs

• Restoring Individual Tables

• LRU dump backup

Implementation

• Implementation Details

• xtrabackup Exit Codes

References

• The xtrabackup Option Reference

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: 2022-07-19