Restore a MySQL instance and database
You can restore a MySQL instance or database either to an original backup location or to an alternate location. You can choose to recover from the default copy of the instance or database. The default copy is also known as the primary copy.
To restore a MySQL instance
- On the left, click Workloads > MySQL.
- On the Instances tab, select the instance that you want to recover.
- Click Recover from the top bar.
- On the Recovery points tab, select the date with available backup.
Note:
In the calendar view, dates with available backups are indicated with a green dot.
- From the listed Backup images/ Recovery points, select the desired image or recovery point.
Note:
The backup images or recovery points are listed in rows with the respective backup timestamp.
- Click Actions > Perform complete instance recovery.
- Click the search icon in Host field, select the desired host and click Save.
If the recovery is to alternate an host, then select the corresponding valid credentials from the displayed list.
For more information, See Restore target options.
- Select the appropriate instance directory path from one of the following options:
Restore everything to original location: Files are restored to the location where they were originally backed up from.
Restore everything to a different location: Files are restored to alternative location that you can specify. The folder structure of the restored data within the alternate location will be the same as that of the original data that is same folder and sub-folder setup.
Directory for restore - This is MySQL data directory. MySQL full backup data and binary logs would be restored to the specified path.
For more information, See Restore target options.
- Click Next and follow the instructions prompted.
- On the Recovery source tab, review the storage details.
- Click Next.
- On the Recovery points tab, select the Restore or Restore and recovery option to perform instances and database restore and recovery:
Restore - Will restore the instances.
Restore and recovery - Will recover the instances.
Note:
For LVM and VSS if Restore and Recovery option is selected, then contents of target data directory would be deleted by recovery operation.
Note:
In the Restore and recovery option, the MySQL service must be up and running. If the service is stopped, the restore will fail. The data folder must be empty, to run the Restore option on the same path. If the folder is not empty, then, the data will not restored.
- Click Next.
- On the Review tab, review the details and click Start recovery.
Note:
In case of recovery, a backup of the configuration file
/etc/my.cnfwith name/etc/backup.cnfis created.
To restore a MySQL database
- On the left, click Workloads > MySQL.
- On the Databases tab, select the database that you want to recover.
- Click Recover from the top bar.
- On the Recovery points tab, select the date with available backup.
Note:
In the calendar view, dates with available backups are indicated with a green dot.
- From the listed Backup images/ Recovery points, select the desired image or recovery point.
Note:
The backup images or recovery points are listed in rows with the respective backup timestamp.
- Click Actions > Perform complete database recovery.
- Click the search icon in Host field, select the desired host and click Save.
If the recovery is to alternate an host, then select the corresponding valid credentials from the displayed list.
For more information, See Restore target options.
- Select the appropriate Database directory paths from one of the following options:
Restore everything to original location: Files are restored to the location where they were originally backed up from.
Restore everything to a different location: Files are restored to alternative location that you can specify. The folder structure of the restored data within the alternate location will be the same as that of the original data that is same folder and sub-folder setup.
Directory for restore - This is MySQL data directory. MySQL full backup data and binary logs would be restored to the specified path.
For more information, See Restore target options.
- Click Next and follow the instructions prompted.
- On the Recovery source tab, review the storage details.
- Click Next.
- On the Recovery points tab, select the Restore or Restore and recovery option to perform instances and database restore and recovery:
Restore - Will restore the database.
Restore and recovery - Will recover the database.
- Click Next.
- On the Review tab, review the details and click Start recovery.