Tablestore:Restore data

Procedure

1. Navigate to the Create Restore Job page.

   1. Log on to the Tablestore console.

   2. In the left-side navigation pane, click Data Backup.

   3. On the Data Backup page, select the region where the resource to be restored is located.

      The system automatically retrieves a list of instances in the selected region.

   4. In the Actions column of the target instance, click Restore.

2. Configure the restore settings.

   1. Configure the data restore parameters.

      Parameter	Description
      Recoverable Tables	The name of the table to restore. The available tables are based on the table names you specified when you created the backup. Each restore job can only restore one table and its associated search indexes. Note If the destination table does not exist, the restore job creates a new table based on the backup.
      Recoverable Time Point	The time range during which data can be restored. Your backup plan's schedule determines this range.
      Choose Recovery Point	The point in time to which you want to restore the data. Drag the timeline slider to set a specific time.

   2. By default, the system regenerates auto-increment columns and restores search indexes. Modify these restore options as needed.

      Restore options	Description
      Regenerate Auto-increment Columns	This option regenerates the auto-increment column for the data table during the restore. The Regenerate Auto-increment Columns switch is enabled by default and cannot be disabled. Important This setting has no effect if the table did not have an auto-increment primary key column when it was backed up. When restoring a table with an auto-increment column, Cloud Backup only restores putRow operations and ignores updateRow and deleteRow operations. If multiple putRow operations occurred on the same logical row in the source table (where all primary keys except the auto-increment column are identical), each putRow operation creates a new, distinct row in the restored table.
      Restore Search Indexes	Specifies whether to restore the search indexes associated with the table. The Restore Search Indexes switch is enabled by default. If you do not need to restore the search indexes, disable the Restore Search Indexes switch. Important This setting has no effect if the table did not have a search index when it was backed up.

   3. Click Next.

3. Configure the target instance.

   1. Select the destination Tablestore instance.

      The list shows all Tablestore instances that are in the same region and under your account. Selecting a different Tablestore instance allows you to perform a cross-instance restore for Tablestore data within the same account and region.

   2. The system generates a new name for the restored table by default. You can change the name as needed.

      Important

      The restore job overwrites rows in the destination table that have the same primary key. Other rows are not affected.

4. Click OK.

   After the restore job is created, you can monitor its progress in the Status column on the Restore Jobs tab. The restore is complete when the Status changes to Completed and the progress reaches 100%.

   To cancel a running restore job, click Cancel in the Actions column for the job, and then click OK to confirm.

Verify the result

In the Tablestore console, verify the configuration and data of the restored table.

1. Log on to the Tablestore console.

2. At the top of the Overview page, select the region.

3. Click the name of the destination instance.

4. On the Instance Details page, in the Tables section, click the name of the restored table.

5. Verify the information of the restored table.

   • On the Basic Information tab, check the table's basic information, primary keys, and predefined columns.

     Note

     If the table properties or predefined column settings do not meet your requirements, you can modify them manually.

   • On the Query Data tab, verify that the data has been restored to the table.