Restoration Solutions

If your database is damaged or mistakenly deleted, you can restore it from backups.

Restoring or Migrating Data to GaussDB(for MySQL)

Restoring data to GaussDB(for MySQL): You can restore data from backups. For details, see Restoring a DB Instance from Backups.
Migrating data to GaussDB(for MySQL): You can migrate data using DRS, mysqldump, or DAS. For details, see Data Migration Schemes.

Restoration Solutions for 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 restoration solution if needed.

**Table 1** Restoration solutions for misoperations
Scenario	Restoration Solution	Restoration Scope	Restore To	Operation Guide
Deleting an instance by mistake	If the deleted instance is in the recycle bin, rebuild it by referring to Rebuilding a DB Instance in the Recycle Bin.	All databases and tables	Original instance	Rebuilding a DB Instance
Deleting an instance by mistake	If a manual backup has been created (Creating a Manual Backup) before the instance is deleted, restore the instance on the Backups page.	All databases and tables	New instance Existing instance Original instance	Restoring a DB Instance from Backups
Deleting a table by mistake	Use the database table restoration method to restore the table.	All database tables Some database tables	New instance Existing instance Original instance	Restoring Tables to a Point in Time
Deleting a database by mistake	Use the database table restoration method to restore the database.	All database tables Some database tables	New instance Existing instance Original instance	Restoring Tables to a Point in Time
Overwriting the entire table and deleting or modifying columns, rows, or data in a table by mistake	If a misoperation affects more than 100,000 data records, use the database table restoration method to restore data in the table.	All database tables Some database tables	New instance Existing instance Original instance	Restoring Tables to a Point in Time