Monday , May 20 2024

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



Lastly giving mysql privilege to data directory




About Anil Joshi

Leave a Reply

Your email address will not be published. Required fields are marked *