After you use Cloud Backup 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 data of the MySQL database to the source MySQL database or another registered MySQL database within the same account in the same region.
Prerequisites
A MySQL database is backed up in the Cloud Backup console. For more information, see Back up a MySQL database.
The MySQL database is in the Online state. If the status of the MySQL database restored to the destination is abnormal, the restore job fails. For more information, see FAQ about the database backup feature of Cloud Backup.
Billing
You are not charged for the restore feature.
Precautions
The backup speed and recovery speed of Cloud Backup are obtained in a test environment. The values are provided for reference only. For more information, see Backup speed and recovery speed.
If you want to restore data to a new MySQL database, you must register the MySQL database in the Cloud Backup console and make sure that the database is in the Online state.
Create a restore job for the MySQL database
To create a restore job, perform the following steps:
Log on to the Cloud Backup console.
In the left-side navigation pane, choose . In the top navigation bar, select a region. On the Database Backup page, click the MySQL tab. Click the ECS Database Instance or Local Database Instance tab. Find the MySQL database for which you want to create a restore job and click Restore in the Actions column.
In the Create Restore Job dialog box, perform the following steps.
Configure Restore Items and click Next.
Manually drag the slider for Recovery Point to specify the time to restore the database.
Specify Plan Name for the restore job and start the job immediately. Then, click Next.
You can only start the restore job immediately. You cannot specify the restoration time.
Configure Restore Config 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. The value 0 indicates that the speed is unlimited.
We recommend that you specify a reasonable speed to prevent database performance issues caused by an excessive amount of data restored.
Forcibly Apply Binlog
If you select this option, binary logs are forcibly used for data restoration even if an error occurs. Binary logs are crucial to recording internal changes in MySQL databases, including the changes in all data definition language (DDL) and data manipulation language (DML) statements.
Ignore Permission Table When Binlog Is Applied
If you select this option, you can prevent denied access to binary logs due to insufficient permissions when you restore logs.
Select a database to which you want to restore the data of the source database and click Create.
By default, the MySQL database that is last backed up is selected. You can also restore the data to another registered MySQL database.
After you create a restore job, the job automatically starts. On the Restore Plan tab, you can view the created restore job. After the restore job is completed, the job status changes to Completed.
Then, you can log on to the MySQL database to verify data.
FAQ
What do I do if the status of a MySQL database is Database Offline?