Restore universe YSQL data

• YSQL
• YCQL

You can restore YugabyteDB universe YSQL data from a backup as follows:

1. Open your universe and select Backups.

2. Click Restore Backup to open the Restore data to dialog shown in the following illustration:

   
   
   

3. Complete the following fields:

   • Storage: Select the storage configuration type: GCS Storage, S3 Storage, or NFS Storage.
   • Storage Location: Specify the storage location.
   • Universe: Select the universe to restore.
   • Keyspace: Leave blank. This is used for YCQL data only.
   • Table: Leave blank. Backup and restore of YSQL data is for full universe data only.
   • Parallel Threads: Default is 8. This value can be changed to a value between 1 and 100.
   • KMS Configuration: Optional, if the backup was from a universe that has encryption at rest enabled, then select the KMS configuration to use.

4. Click OK.

   
   The restore begins immediately. When finished, a completed Restore Backup task appears in the Tasks tab.

5. To confirm the restore succeeded, select Tables to compare the original table with the table to which you restored, as per the following illustration: