CODEWITHSUNDEEP
mysqldatabase-backupsmariadbpercona
The Georgia
The Georgia

Reputation: 1075

Percona xtrabackup

I installed percona xtrabackup on CentOS-6 and it installed just fine. However, i cannot seem to find any blog or documentation that shows how to configure or run xtrabackup to actually backup my databases. I would like to configure an automatic backup if possible. Can anybody show me how this is done, or point me to some site that shows step-by-step how to backup databases using percona xtrabackup?

Upvotes: 1

Views: 1211

Answers (2)

David H. Bennett
David H. Bennett

Reputation: 1842

You can download the Percona XtraBackup User Manual for free here

Upvotes: 0

Tan Hong Tat
Tan Hong Tat

Reputation: 6879

Simply setup a cron job with the parameters and values.

For example: This does a compressed backup to the /backup folder every night.

0 0 * * * innobackupex --stream=tar --user=<user> --password=<pass> ./ 2>&1 | gzip - > /backup/backup-db-`date +\%Y\%m\%d`.tar.gz

Upvotes: 1

Related Questions