Site icon Database Tutorials

Mysql Physical Backup Using Percona Xtrbackup Tool

 

Percona Xtrabackup is  open source  backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing backup.

 

Installation using yum repository

1. First,installing yum repos.

 

2.Check the required package

 

3.Finally, installing the package

Taking Backup

First,creating a user for backup purpose

 

Now take backup using below command

It will create backup in /home/backup_folder/ directory

 

Restoration of Backup

First,we need to prepare our backup for restoration purpose

 

Finally,restoring the prepared backup

or

 

Lastly giving mysql privilege to data directory

 

Ref:- https://www.percona.com/doc/percona-xtrabackup/LATEST/index.html

Exit mobile version