Help Center> Relational Database Service> FAQs> Backup and Restoration> How Can I Retrieve the Databases and Tables Deleted by Mistake?
View PDF

How Can I Retrieve the Databases and Tables Deleted by Mistake?

HUAWEI CLOUD Data Admin Service (DAS) is a professional tool that simplifies database management.

You can use DAS to retrieve the data that is deleted by mistake and roll it back to the original status. You are also advised to enable SQL audit to record database operations.

Scenarios

  • Audit core data changes, collect change statistics, and view sensitive information. For example, you can use this function to query bank statements, statistics on new orders, and key configuration changes.
  • Roll back the misoperation to the state before it is operated. For example, you can use the rollback function when the WHERE condition is not added during DBA configuration update, configuration data is deleted by mistake, or a large amount of dirty data and ripple effects are generated due to program bugs.

Operation Entrance

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service to go to the RDS console. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and click Log In in the Operation column.

    Alternatively, click the target DB instance on the Instance Management page. On the displayed Basic Information page, click Log In in the upper right corner of the page.

  5. On the displayed login page, enter the correct username and password and click Log In.

Procedure

For operation details, see Data Tracking and Rollback in the Data Admin Service User Guide.

Parent topic: Backup and Restoration