Database/Table Rollback by Backup Set

Recent Pages

Database/Table Rollback by Backup Set

Last updated: 2023-09-12 14:55:44

If you can't specify a time point for data rollback, you can use a backup set to restore the database to a certain status at a faster rate.
Prerequisites
There are data backup files in the backup list. For automatic backup settings, see Automatic Backup.
The cluster is in the running status.
Note
For database/table rollback, you need to specify the database/table to be rolled back. If you cannot determine all the involved databases/tables, we recommend that you clone the original cluster and migrate back to it after determining the databases/tables.
If the database/table to be rolled back does not exist at the specified time point, database/table rollback will fail.
If the database/table to be rolled back does not exist or has been dropped, you need to log in to the database and create a database/table first before performing rollback in the console.
If there are primary or foreign key constraints in the specified database/table to be rolled back, please ensure that the associated databases/tables exist during the rollback process; otherwise, database/table rollback will fail.
Up to 500 databases or tables can be rolled back at a time.
Step 1. Roll back databases/tables
1. Log in to the TDSQL-C for MySQL console.
2. Select a region at the top and proceed according to the actually used view mode.
Tab view
List view
Click Target Cluster in the cluster list on the left to enter the cluster management page.
﻿
Find the target cluster in the cluster list and click the Cluster ID or Manage in the Operation column to enter the cluster management page.
﻿
3. On the cluster management page, select the Backup Management tab and click Roll Back.
﻿
4. On the database/table rollback page, set the rollback mode to By backup file. Then, select the database/table to be rolled back, rename it, and click Roll Back.
﻿
﻿
5. In the pop-up window, confirm that everything is correct and click OK to initiate the rollback task.
6. After the task is submitted, you can click View Rollback Task or go to the task list to view the rollback progress and task details.
7. After the rollback is completed, you can see the new restored database/table in the original cluster and perform next operations.
Step 2. Compare the data
After the databases/tables are rolled back, you can log in to the cluster through DMC to compare and verify the data.
1. Log in to the TDSQL-C for MySQL console.
2. In the cluster list, find the rollback cluster and click Log In.
3. On the login page, enter the cluster account and password, and click Log In.
﻿
﻿
4. After entering the DMC management page, select the rollback database from the drop-down menu on the left and find the misoperation data. Then, verify that the data has been rolled back to its original status and other data is also consistent with how it was before the misoperation.
﻿
﻿