Updated on 2026-07-09 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

Databases are deleted by mistake.

Use the database/table restoration method to restore the databases.

  • All databases and tables
  • Certain databases and tables

Restoring Data of Deleted Databases

If database/table recycle bin is enabled before the databases are deleted, restore them by executing commands.

Certain databases and tables

Tables are deleted by mistake.

Use the database/table restoration method to restore the tables.

  • All databases and tables
  • Certain databases and tables

Restoring Data of Deleted Tables

If database/table recycle bin is enabled before the tables are deleted, restore them by executing commands.

Certain databases and 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