SnapProtect - Restore - MySQL iDataAgent

Perform a Restore

As restoring your backup data is very crucial, it is recommended that you perform a restore operation immediately after your first full backup to understand the process.

Before attempting a restore, we recommend you to save the data present on the destination server to a removable media. Then, clean up the data directories of the server and shut down the server. If you do not clean up, the existing data and the restored data together might make the destination server inconsistent.

Whenever the MySQL database is corrupt or lost, you can restore and recover it from the latest full backup.

Partial database restores are currently not supported. We only support entire server restore.

  1. From the CommCell Console, navigate to Policies > Storage Policies.

    Right-click the storage_policy and click Properties.

    Click the Copy Precedence tab.

    By default, the snapshot copy is set to 1 and is used for the restore operation. You can also use a different copy for performing the operation. For the copy that you want to use, set the copy precedence as 1.

    Click OK.

  1. From the CommCell Browser, navigate to Client Computers | client | MySQL.

    Right-click the instance, point to All Tasks, and then click Browse and Restore.

  2. Click the Advanced Options tab.

    Select the MediaAgent that was used during the storage policy creation from the Use MediaAgent drop-down list. This MediaAgent should be the one you installed along with your agent.

    Click View Content.

  3. In the right pane of the window, select the entire instance or all the databases that you want to restore and click Recover All Selected.

    Note: The SnapProtect SnapProtect feature supports a whole instance restore.

  4. Click Browse to select Staging Location.

    Click OK.

  5. You can monitor the progress of the restore job in the Job Controller.

  6. Once the restore job has completed, right-click the agent or <Instance>, point to View and click Restore History.

  7. Click OK.

  8. You can view the following details about the job by right-clicking the job:
    • View Restore Items - You can view them as Successful, Failed, Skipped or All.
    • View Job Details
    • View Events of the restore job.
    • View and send Log files of the restore job
    • Resubmit the restore job

  9. Once the files are restored, verify that the restored files and folders are available in the restore destination provided in step 4.

    mysql> show databases;
    | Database |
    +--------------------+
    | mysql |
    | performance_schema |
    | test |
    +--------------------+

If you want to further explore this Agent's features read the Advanced sections of this documentation.