Restoring a DB Instance from a Cross-region Backup

Scenarios

GaussDB(for MySQL) can store backups in a different region from your DB instance. If your DB instance is faulty, you can use a backup to restore data to a new DB instance in the region where the backup is stored.

Prerequisites

A cross-region backup has been created. For details, see Configuring a Cross-Region Backup Policy.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > GaussDB(for MySQL).
4. In the upper left corner of the page, select the region where the backup is located.
5. In the navigation pane, choose Backups. On the displayed page, click the Cross-Region Backups tab.
6. Locate the target DB instance and click View Cross-Region Backup in the Operation column.
   Figure 1 Cross-region backups
   

7. On the displayed page, select the backup to be restored.

   Currently, full and incremental backups can be restored to new DB instances.

   Restoring a full backup

   1. Locate the target backup and click Restore in the Operation column.
      Figure 2 Restoring a full backup
      

   2. In the displayed dialog box, confirm instance details and click OK.
      Figure 3 Restoring a full backup to a new DB instance
      

   3. On the displayed page, set the parameters of the new DB instance and click Next.
      • The region, DB engine, and DB engine version are the same as those of the original DB instance and cannot be changed.
      • The default database port is 3306.
      • Other settings are the same as those of the original DB instance by default but can be modified. For details, see Buying a DB Instance.

   Restoring an incremental backup

   1. Click Restore to Point in Time.
      Figure 4 Restoring an incremental backup
      

   2. Select the date and time range, and select or enter a time point within the time range.
      Figure 5 Restoring an incremental backup to a point in time
      

   3. Click OK.
   4. On the displayed page, set the parameters of the new DB instance and click Next.
      • The region, DB engine, and DB engine version are the same as those of the original DB instance and cannot be changed.
      • The default database port is 3306.
      • Other settings are the same as those of the original DB instance by default but can be modified. For details, see Buying a DB Instance.