After you use Hybrid Backup Recovery (HBR) to back up a MySQL database to a backup vault, you can restore the MySQL database based on your business requirements. You can restore the database to the original MySQL instance, another MySQL instance that uses the same backup vault, or a MySQL instance in another region.

Prerequisites

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

Create a restoration job

To create a restoration job, perform the following steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > Database Backup.
  3. In the top navigation bar, select a region.
  4. Click the ECS Database Instance or Local Database Instance tab.
  5. On the ECS Database Instance or Local Database Instance tab, find the MySQL instance for which you want to create a restoration job. Click Restore in the Actions column to the right of the MySQL instance.
  6. In the Create Restore Job panel, configure the following settings as prompted.
    1. Set the restoration parameters and click Next.
      Click Recovery Point to specify the point in time to which the database is restored.
    2. Configure the restoration plan and click Next.
      Parameter Description
      Plan Name The name of the scheduled restoration job.
      Restore Time Run Now. This value indicates that the restoration job is immediately run.
    3. Configure the restoration settings and click Next.
      Parameter Description
      Retry Time The time interval between two consecutive reconnection attempts if the database is disconnected during restoration. Unit: minutes.
      Speed Limit The maximum size of data that is restored per second. Unit: MB/s.
    4. Configure the restoration settings and click Create.
      Select a database instance. By default, the MySQL instance that is last backed up is selected.
    After you create a restoration job, the job automatically starts. On the Restore Jobs tab, you can view the status of the restoration job.