Restoring Data of a Deleted Instance

Scenarios

If an instance is deleted by mistake, you can rebuild it or use manual backups to restore its data.

This section uses pre-provisioned data to simulate an accidental deletion, guiding you through the entire process of restoring instance data on the console.

Operation Process

Step 1: Create a Database

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, click the instance name.
5. In the navigation pane, choose Databases.
6. Click Create Database. In the displayed dialog box, enter a database name (for example, principles) and click OK.

Step 2: Create a Table and Insert Data

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. 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.

5. Enter the database username and password and click Test Connection. After the connection test is successful, click Log In.
6. On the top menu bar, choose SQL Operations > SQL Query.
7. Select database principles and run the following SQL statements to create a table and insert data into it:
   • Creating a table

     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;

   • Inserting data

     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');

8. Query table data.

   SELECT *  FROM solid_principle;

Step 3: Delete the Instance

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. On the Instances page, locate the instance you want to delete and click More > Delete in the Operation column.

   Alternatively, click the instance name to go to the Basic Information page. In the upper right corner of the page, click and choose Delete.

5. In the displayed dialog box, enter DELETE and click OK. Refresh the Instances page later to check that the deletion is successful.

Step 4: Restore the Instance

Rebuild the instance from the recycle bin within the retention period, or restore it from backups.

Step 6: Check the Restoration Results

1. Log in to the console.
2. Click in the upper left corner and select a region and project.
3. Click in the upper left corner of the page and choose Databases > TaurusDB.
4. 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.

5. Enter the database username and password and click Test Connection. After the connection test is successful, click Log In.
6. Check the database name and table data to verify if the restoration is complete.