Updated on 2025-05-14 GMT+08:00

Restoration Methods

Restoration Methods for Data Misoperations

There are many scenarios where data can be accidentally mishandled, such as deleting a table, database, or instance, overwriting the entire table, and deleting or modifying columns, rows, or data in a table by mistake. You can choose an appropriate data restoration method based on the site requirements.
Table 1 Restoration methods for misoperations

Scenario

Restoration Method

Restoration Scope

Operation Guide

An instance is deleted by mistake.

Recycle bin: Locate the deleted instance in the recycle bin and rebuild the instance to restore it.

All databases and tables

Restoring Data of a Deleted Instance

Instance backup: If a manual backup has been created before the instance is deleted, restore the instance on the Backups page.

All databases and tables

A database is deleted by mistake.

Use the database and table restoration method to restore the database.

  • All databases and tables
  • Certain databases and tables

Restoring Data of Multiple Deleted Databases

A table is deleted by mistake.

Use the database and table restoration method to restore the table.

  • All databases and tables
  • Certain databases and tables

Restoring Data of Deleted Tables

An entire table is overwritten, or the columns, rows, or data in a table is deleted or modified by mistake.

If more than 100,000 data records are accidentally mishandled, use the database and table restoration method to restore table data.

  • All databases and tables
  • Certain databases and tables