Restore From Vembu Client GUI

MySQL Server Restore

  • Click restore option in top menu.
  • Choose the MS SQL backup you wish to restore from the list of backups displayed and click on ‘Restore’ option alongside the backup.

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:

  • Select the data(Files/folders) to restore from MySQL backup.
  • You can either select entire backup for restore or choose specific database files.

Step 3- Restore Settings:

This step has following options:

Password- If backup is password protected, enter the password provided to proceed with restore.

Restore machine- By default, this will be chosen as same machine.

Restore Deleted files- Let user decide, what to do with the deleted files in a backup schedule:

    • Skip deleted files in restore
    • Restore deleted files only
    • Include deleted files in restore

Restore to- This option gives 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 user to specify a alter location where backup data can be restored to.

Advanced Option:

When backup data is restored, it is possible that source files are already present in restore location. In this case, OnlineBackup 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 restored file with *.SG extension and keep existing files (This is the default option selected).
  • Rename existing file with *.SG extension and restore backup file as it is.
  • Overwrite existing file with restored file (If 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).

Step 4- Run Restore:

Once all options are chosen, review the configuration provided and click 'Restore now'. Review restore progress and make sure it gets completed successfully.