This topic describes how to restore a MySQL database from Database Backup.

Prerequisites

The database is backed up. For more information, see Back up a MySQL instance.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
    Select a region
  3. On the Backup Schedules page, click Manage in the Actions column corresponding to the ID of the backup schedule based on which you want to create physical backups.
  4. On the Configure Task page, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step of the Create Restore Task wizard, set the parameters as described in the following table and click Next.
    Note If this example, backup data is restored to a new instance. If you set the Target database instance type parameter to Use Exists, you must set more parameters. For more information, see Back up a MySQL instance.
    Restore a MySQL database
    Section Parameter Description
    N/A Task Name The name of the restoration task. DBS generates a task name. We recommend that you set a descriptive name that makes the task easy to identify. Task names do not need to be unique.
    Set Time Restored To Time Range Available to Restore The time range available to restore the source instance. DBS displays the available time range.
    Restore To The point in time to which you want to restore the source instance. The value must be within the time range that is specified by the Time Range Available to Restore parameter.
    Configure Destination Database Target database instance type The type of the database instance to which you want to restore data. Valid values: New (Recommend) and Use Exists.
    Database Location The location of the new instance. Default value: RDS Instance.
    Instance Region The region in which the new instance is deployed.
    VPC The VPC in which the new instance is deployed.
    Note For more information about how to create a VPC, see Create a default VPC network and VSwitch.
    Backup Gateway The backup gateway installed to restore data. For more information about how to install a backup gateway, see Add a backup gateway.
    Note This backup gateway is installed on the destination server.
    DB InstanceClass The type of the new instance. The available instance types are displayed in the DBS console.
    Note We recommend that you select the same instance type as the source instance or an instance type with higher specifications.
    Storage space (GB) The storage space of the new instance. The available storage space sizes are displayed in the DBS console.
  6. In the Configure Objects to Restore step, set the parameters as described in the following table and click Precheck.
    Parameter Description
    Conflict Handling Select one of the following methods for Conflict Handling:
    • Fail when Object with the Same Name Exists.
    • Rename Object with the Same Name: If you select this option, DBS renames the new table that is to be created by the restoration task. For example, a table to be restored in the source database and an existing table in the destination database have the same name job_info. The system renames the new table that is restored from the table in the source database in the following format: job_info_dbs_<ID of the restoration task>_</Timestamp>.
    Objects to Restore The database or table that you want to restore. Select the database or table that you want to restore in the Available section and click the right arrow to add it to the Selected section.
  7. If the Precheck Passed message appears, click Start Task.