mariadbHow to use xtrabackup in Mariadb?

XtraBackup is a free open source tool for performing hot backups of MariaDB databases. It can be used to back up a single database, multiple databases, or an entire MariaDB server.

To use XtraBackup, you need to install the XtraBackup package on your MariaDB server.

Once installed, you can use the following command to back up a single database:

xtrabackup --backup --target-dir=/backup/dbname

This will create a backup of the database in the /backup/dbname directory.

To restore the database, you can use the following command:

xtrabackup --prepare --target-dir=/backup/dbname

This will prepare the backup for restoring.

Finally, you can restore the database using the following command:

xtrabackup --copy-back --target-dir=/backup/dbname

This will restore the database from the backup.

Helpful links

• XtraBackup Documentation
• MariaDB Backup and Recovery

Edit this code on GitHub