Restoring Databases or Tables Using a Backup

Scenarios

When a table-level automated backup policy is enabled or a manual backup is available, you can restore tables to the exact state captured by an existing backup, recovering any accidentally or intentionally deleted data.

Procedure

Step 1: Prepare Data

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 > GaussDB.
4. On the Instances page, locate the instance and, in the Operation column, click Log In to access the DAS console.

   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 menu bar on top, choose SQL Operations > SQL Query.
7. In the SQL execution window, run the following statement to create a database:

   CREATE DATABASE db_tpcds;

   If information shown in the following figure is displayed, the creation was successful.

   Figure 1 Creating a database
   

   Switch to the newly created database db_tpcds in the upper left corner.

8. Use SQL statements to create a table and insert data.
   • Create a schema.

     CREATE SCHEMA myschema;

     Switch to the newly created schema in the upper left corner.

   • Create a table named mytable that has only one column. The column name is firstcol and the column type is integer.

     CREATE TABLE myschema.mytable (firstcol int);

   • Insert data into the table.

     INSERT INTO myschema.mytable values (100);

9. Query table data.

   SELECT * FROM myschema.mytable;

Step 2: Delete Table Data

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 > GaussDB.
4. On the Instances page, locate the instance and, in the Operation column, click Log In to access the DAS console.

   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 menu bar on top, choose SQL Operations > SQL Query.
7. Delete table data.

   DELETE FROM myschema.mytable WHERE firstcol = 100;

Step 3: Restore Table Data

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 > GaussDB.
4. On the Instances page, click the name of the instance to access the Basic Information page.
5. In the navigation pane, choose Backups. On the displayed page, click the Table Backup tab.
6. Locate the backup and click Restore in the Operation column.
7. Set Restoration Method to Restore to Original, and click Next.
   Figure 2 Restore Table Backup
   

8. Select the tables to be restored and click Submit.

   

9. Go to the Instances page and check that the target instance is in the Restoring state. When the instance status changes to Available, the restoration is complete.

Step 4: Check the Results

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 > GaussDB.
4. On the Instances page, locate the instance and, in the Operation column, click Log In to access the DAS console.
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 that the restoration is complete.