Monday , May 20 2024

MySQL Enterprise Backup



  • 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



Commands/Statements to perform Restoration



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:


About Engr. Mohammad Rizwan Yasin

Leave a Reply

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