Restoring Data of Deleted Tables

Scenarios

Some table data is lost due to misoperations. This section describes how to restore table data on the console.

Operation Process

Procedure	Description
Step 1: Buy a TaurusDB Instance	Select required basic settings and additional options and buy a TaurusDB instance.
Step 2: Create a Database	Create a database on the TaurusDB console.
Step 3: Create a Table and Insert Data	Create a table and insert data through DAS.
Step 4: Delete Table Data	Log in to DAS and delete the tables.
Step 5: Restore Table Data	Restore the deleted table data using table-level PITR.
Step 6: Confirm the Data Restoration Results	Log in to the DAS and check whether the data is restored.

Notes

Data on the original instance will be overwritten and the original instance will be unavailable during the restoration.

Procedure

Step 1: Buy a TaurusDB Instance

Go to the Buy DB Instance page.
On the Custom Config page, configure basic information for the instance and select region CN-Hong Kong.

Figure 1 Basic configuration

Figure 2 Resource selection
Select instance specifications and retain the default values for other parameters.

Figure 3 Instance options
Set the instance name, administrator password, and enterprise project.

Figure 4 Advanced settings
Click Next and then Submit.
Return to the instance list.

If the instance status becomes Available, the instance has been created.

Step 2: Create a Database

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, click the instance name.
In the navigation pane, choose Databases.
Click Create Database. In the displayed dialog box, enter the database name principles and click OK.

Step 3: Create a Table and Insert Data

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, locate the instance and click Log In in the Operation column.

Alternatively, click the instance name on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner.
Enter the database username and password and click Test Connection.
After the connection test is successful, click Log In.
On the top menu bar, choose SQL Operations > SQL Query.

Run the following SQL statements to create a table and insert data into it:

Create a table and insert data in database principles.

CREATE TABLE `solid_principle` (
  `abbr` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `name_en` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_cn` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`abbr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

insert into solid_principle (abbr,name_en,name_cn) VALUES 
('S','Single Responsibility Principle','Single Responsibility Principle'),('O','Open Close Principle','Open Close Principle'),('L','Liskov Substitution Principle','Liskov Substitution Principle'),('I','Interface Segregation Principle','Interface Segregation Principle'),('D','Dependency Inversion Principle','Dependency Inversion Principle');

Step 4: Delete Table Data

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, locate the instance and click Log In in the Operation column.

Alternatively, click the instance name on the Instances page. On the displayed Basic Information page, click Log In in the upper right corner.
Enter the database username and password and click Test Connection.
After the connection test is successful, click Log In.
On the top menu bar, choose SQL Operations > SQL Query.
Select database principles and run the following SQL statement to delete table data.
```
delete from `solid_principle`;
```

Step 5: Restore Table Data

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, click the instance name.
In the navigation pane, choose Backups. On the Full Backups tab, choose More > Restore Table above the backup list.
On the displayed page, set the restoration date, time range, time point, and tables to be restored.
- After the restoration is complete, new tables with timestamps appended as suffixes to original table names are generated in the instance. You can rename the new tables, but the table names must be unique.
- Time-specific table: The tables to be restored are read from the latest full backup before the selected time point. Recent table: The tables to be restored are read from the selected time point.
- Tables created after the latest full backup are not displayed in the time-specific table list. You can select Recent table to view the latest table details.
- If the tables to be restored are not found or are deleted by mistake, you need to log in to the database and create tables with the same names. Then, the tables to be restored will be displayed when you select Recent table.
Click Next: Confirm. On the displayed page, confirm the information about the tables to be restored and click Restore Now.
On the Instances page, view the instance status, which is Restoring. During the restoration, workloads are not interrupted.

You can also view the progress and result of restoring tables to a point in time on the Task Center page.

Step 6: Confirm the Data Restoration Results

Log in to the management console.
Click in the upper left corner and select a region and project.
Click in the upper left corner of the page and choose Databases > TaurusDB.
On the Instances page, locate the instance and click Log In in the Operation column.
In the displayed dialog box, enter the password and click Test Connection.
After the connection test is successful, click Log In.
Check the table data of the database to verify if the restoration is complete.