Restoring a Table to the Original Cluster

Scenario

Prerequisites

1. Choose Management > Snapshots. Alternatively, in the cluster list, click the name of the target cluster to switch to the Cluster Information page. Then, click Snapshots.
2. Click Create Snapshot in the upper right corner. Alternatively, choose More > Create Snapshot in the Operation column.
3. Click next to Snapshot Level and click Set.

   

4. On the Snapshot List page, toggle the fine-grained snapshot switch.

   : enabled

   : disabled

   

   Note

   • If the fine-grained snapshot is enabled, you can restore specific tables from automatic or manual snapshots.

Procedure

1. Log in to the GaussDB(DWS) console.
2. In the navigation pane, choose Management > Snapshot.
3. In the Operation column of a snapshot, click Restore.
4. On the Restore Table page, configure the following parameters:
   • Database: To restore a cluster snapshot, select a database. To restore a schema snapshot, select the database specified during backup. For details, see Creating a Manual Snapshot and Creating a Manual Snapshot of a Schema.
   • Source Schema: Specify the schema of the table to be restored.
   • Source Table: Specify the name of the table to be restored.
   • Destination Schema: Specify the schema where the table is to be restored to.
   • Destination Table: Specify the name of the new table.

   Caution

   • A table name must meet the following GaussDB(DWS) database naming constraints: The table name is case sensitive can contain up to 63 characters. It must start with a letter or underscore (_). Letters, digits underscores (_) are allowed.
   • The source table to be restored must be a table in the backup set, or the restoration will fail.
   • If the target table already exists in the database, this table will be overwritten during restoration. Check the table name before starting restoration.

5. Confirm the information and click Restore.