MySQL Server Restore
Beginning the Restore:
- To begin the restore process, click the Restore tab. From the list of displayed backup(s) select the MySQL backup that is to be restored.
Step 1- Select version to restore:
- Select the time-stamp version of MySQL backup to restore from and click proceed
Step 2- Select Files/Folders to Restore:
- A tree listing various backup timestamps with the full backup as its parent node will be displayed. This list generated is based on incremental and retention configured. The Restore version will be in the following format: Day/Date/Month/Year/Hours/Minutes/Seconds.
- Select specific database files/folders for the restore and Click Next
Step 3- Restore Settings:
This step has following options:
Password Protected- This option reveals if the backup job that is being restored is encrypted or not. If yes, provide the correct password.
Restore machine- The machine to which the restore is going to happen. By default, this will be chosen as the same machine.
Restore Deleted files- Decide what must me done with the deleted files in a backup schedule:
- Skip deleted files (Restore backup data skipping deleted files) - Choosing this option will not restore the deleted files and skip them instead.
- Deleted files only (Restore deleted files alone) - This option will restore the files that are deleted alone and omit the other backed up data from the restore process.
- Include deleted files (Restore backup data along with deleted files) - This option will restore the backup data along with the deleted files.
Restore to - Configure the location of the restore: You have two choices to choose from:
- Original location- This will restore data to backup source location and if the source files(Original files) are present, the restored files will be saved with a *.SG extension.
- Alternate Restore location- This will allow you to specify a alter location where the backup data can be restored to.
Advanced Options:
When the backup data is restored, it is possible that source files are already present in restore location. In this case, Vembu NetworkBackup will retain source file by default and restore files by renaming with a *.SG extension.
Advanced Settings allow alternate options to change this, they are:
- Rename the restored file with *.SG extension and keep existing files (This is the default option selected).
- Rename the existing file with *.SG extension and restore backup file as it is.
- Overwrite the existing file with restored file (If the existing file is different from backed up file restored, the contents of source files will be lost. Choose this option, if you are sure that current file can be overwritten). Choosing this option will display the alert shown below.
Step 4- Review Configurations:
- You have reached the final step of the restore process wherein you have to review the configuration you have provided and click Restore Now option. This will trigger the restore process. Review restore progress and make sure it gets completed successfully.
- You can view the status of your MySQL restore from the Status option. Once you click the inverted arrow mark, the page displayed below will be available.
The following details will be available in the Restore Progress Page:
Job Name: Name of the backup job
Backup Of: Client Name
Restore from: From where the restore is happening, either from Client or Server
Restore to: To where the restore is happening.
Restore Directory: The location to where the restore is taking place.
Warnings (If any)
Transfer Rate: Speed at which the restore is occurring
Transferred Size: The amount of backup data that is transferred
Original Size: The actual size of the backup data
Time Left: Time remaining for the restore to complete.
Current Progress: The progress of the restore, it will depend on how much data is restored.
- You can abort your restore if not required from the Abort (-) option available in that window. You will get a pop up as shown below. Click OK to Abort your restore.
Note: To enhance your restore performance, close the progress window and open it only occasionally to check restore progress.
- You can suspend your restore if not required from the Suspend option available in that window. You will get a pop up as shown below. Click OK to Suspend your restore.
