Chat now with support
Chat with Support

NetVault Plug-in for MySQL 11.2 - User Guide

Introducing NetVault Backup Plug-in for MySQL Installing and removing the plug-in Configuring the plug-in Backing up data Restoring data Working with native MySQL replication Using the plug-in in a Failover Cluster environment Troubleshooting

Examples of restore scenarios for MySQL Enterprise Backup

To recover from a failure or data corruption, various settings must be made when setting up the job regarding data selected for restore and options available on the Options tab.

•
Full Backup only restore scenarios
•
Full and Incremental Backup restore scenarios

Full Backup only restore scenarios

1
To generate a prepared Full Backup to be restored, submit a job in which you have selected the Restore, Extract Raw Full Backup… option on the Options tab.
2
To shut down MySQL and copy the prepared Full Backup to the MySQL Server repository, submit a job in which you have selected the Shutdown MySQL Server and Copy Back… option on the Options tab.
3
Restart the MySQL Server by entering the applicable command at a command prompt.

Full and Incremental Backup restore scenarios

1
To generate a prepared Full Backup to be restored, submit a job in which you have selected the Restore, Extract Raw Full Backup… option on the Options tab.
2
To apply the required Incremental Backups to the prepared Full Backup in the order in which they were backed up, submit the applicable number of jobs in which you have selected the Restore, Extract Incremental Backup… option on the Options tab.
3
To shut down MySQL and copy the prepared Full Backup to the MySQL Server repository, submit a job in which you have selected the Shutdown MySQL Server and Copy Back… option on the Options tab.
4
Restart the MySQL Server by entering the applicable command at a command prompt.

Using advanced restore procedures for MySQL Standard/Community

This topic describes other restore operations that you can perform with the plug-in for the MySQL Standard/Community option.

•
Renaming a database during a restore
•
Restoring to a different MySQL Instance on the same server
•
Recovering to an alternate MySQL Server
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating