Restoring an Individual Table
In addition to the cluster-level backup and restore features, you can restore an individual table to an existing database or a different database. To get started, click the EXPLORE button in the Clusters view:
Figure 1 – The EXPLORE button
In the Explorer view, switch to the Schema tab:
Figure 2 – The Schema tab
Click the vertical dots icon next to the table you want to restore and select Restore from Backup:
Figure 3 – The Restore from Backup menu item
Select the backup you want to restore from. By default, the table will be restored from the selected backup into the same database.
NOTE: If you’re restoring a table to the same database, the table is first removed from the database. Once the table is removed, it is restored from the selected backup.
Figure 4 – Restoring the table to the same database
You also have the option of restoring the table from the selected backup to a different database. Select the Different database radio button, then enter the name of the other database:
Figure 5 – Restoring the table to a different database
When you’re ready to restore the table, click CONFIRM. When the table is restored, you’ll see a message in the ACM:
Figure 6 - Table restored success message