Restoring Data of a Deleted Instance

1. Go to the Buy DB Instance page.
2. 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
   

3. Select instance specifications and retain the default values for other parameters.
   Figure 3 Instance options
   

4. Set the instance name, administrator password, and enterprise project.
   Figure 4 Advanced settings
   

5. Click Next and then Submit.
6. Return to the instance list.

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

1. Log in to the management 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.

1. Log in to the management 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;

1. Log in to the management 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.

Rebuilding an instance

You can rebuild instances within the retention period from the recycle bin.

1. Log in to the management 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 Recycle Bin page, locate the instance you want to rebuild and click Rebuild in the Operation column.
5. On the displayed page, set required parameters.
6. Click Next.
7. Confirm the information and click Submit.

Restoring an instance using a backup

1. Log in to the management 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. In the navigation pane, choose Backups. On the displayed page, locate the latest manual backup and click Restore in the Operation column.
5. Select where you want to restore the backup to:
   • A new instance
     1. Set Restoration Method to Create New Instance and click OK.
        Figure 5 Restoring to a new instance
        

     2. On the displayed page, set required parameters and click Next.
        • The region and DB engine version of the new instance are the same as those of the original instance and cannot be changed.
        • The database port is 3306 by default.
        • Other settings are the same as those of the original instance by default and can be modified. For details, see Buying a DB Instance.
   • An existing instance
     1. Set Restoration Method to Restore to Existing, select the confirmation check box, select an existing instance, and click Next.
        Figure 6 Restoring to an existing instance
        

     2. Confirm the task details and click OK.
        • Restoring to an existing instance will overwrite its data and the root password. The existing instance is unavailable during the restoration. Instances will not be displayed unless they have the same DB engine type, version, and table name case sensitivity as the original instance.
        • If the original password of the existing instance cannot be used to connect to the database after the restoration, you can reset the password. For details, see Resetting the Administrator Password.

6. View the restoration results.
   • Restoring the backup to a new instance

     A new instance is created, where data is restored based on the point in time when the backup was created. When the instance status changes from Creating to Available, the restoration is complete.

     The new instance is independent from the original one. If you want to offload read pressure from the primary node, create one or more read replicas for the new instance.

     After the restoration, a full backup will be automatically triggered.

   • Restoring the backup to an existing instance

     On the Instances page, when the instance status changes from Restoring to Available, the restoration is complete. If the existing instance contains read replicas, the read replica status is the same as the existing instance status.

     After the restoration, a full backup will be automatically triggered.

1. Log in to the management 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.