Restoring a Database Group for Google Cloud SQL for MySQL

You can browse and restore one or more databases for Google Cloud SQL for MySQL.

Before You Begin

• Verify that the Cloud Resource Manager API is enabled.

• Before initiating the out-of-place restores, create the destination instance and start the destination server.

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Databases page appears.

2. On the Instances tab, click the instance.

   The instance page appears.

3. On the Database groups tab, for the database group that you want to restore, click the action button , and then click Restore.

   The Backup content page appears.

4. Select the databases that you want to restore, and then click Restore.

   The Restore options dialog box appears.

5. Follow the steps for the type of restore operation you want to run:

   • To run an in-place restore operation, do the following:

     1. Click the In place option.

        For an in-place restore operation, the destination client and the destination instance are the same as the source client and the source instance.

     2. Select a MediaAgent from the MediaAgent list.

   • To run an out-of-place restore operation, do the following:

     1. Click the Out of place option.

     2. Select the Restore type.

     3. Select the Destination client.

     4. Select the Destination instance.

     5. Select a MediaAgent from the MediaAgent list.

6. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

   1. Click Schedule.

      The Add schedule dialog box appears.

   2. In the Name box, type a name for the schedule.

   3. Configure the Frequency and Repeat parameters.

   4. To specify exceptions to the schedule, click Exceptions.

      The Exceptions dialog box appears.

   5. Configure the exception parameters:

      • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

      • Click Save when you have finished configuring the exception parameters.

   6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

   7. To save the schedule and return to the restore dialog box, click Schedule.

7. Click Submit.