Friday , December 6 2024

MySQL Enterprise Backup

 

Pre-requites:

  • Must have MySQL Enterprise Edition installed
  • Download media file :  meb-4.1.0-el6.x86_64.rpm (For Linux Platform)

 

Installation of MySQL Enterprise Backup

Command to install rpm of MySQL Enterprise Backup : rpm -ivh meb-4.1.0-el6.x86_64.rpm

 

Configuration Setup

Create a user  named:”backup” to perform backup and restrict the permissions accordingly i.e. assign the following permissions

 

By the execution of above command to assign permission this user will be enrolled in BackupAdmin & ProcessAdmin Roles.

 

Command Statement to perform Backups

Full

 

Commands/Statements to perform Restoration

Full

 

Backup Verification:

you can check the status and complete history of backups by the following command.

 

If Enterprise Monitoring tool is configured then you may also view the graphical interface for backups as follows:

Loading

About Engr. Mohammad Rizwan Yasin

Leave a Reply

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