Restoration Solutions

If your database is damaged or mistakenly deleted, you can restore it using the following methods.

Restoring or Migrating Data to GaussDB(for MySQL)

You can restore data using backups. For details, see Restoring a DB Instance from Backups.
You can migrate data using DRS, mysqldump, or DAS. For details, see Data Migration Schemes.

Restoring Deleted or Modified Data

The following table describes how to restore deleted tables, deleted databases, deleted instances, deleted or modified columns, rows, and data in tables, and overwritten tables.

**Table 1** Restoration solutions
Scenario	Restoration Solution	Restoration Scope	Restore To	Operation Guide
Restoring a deleted instance	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	The original instance	Rebuilding a DB Instance
Restoring a deleted instance	If a manual backup has been created before the instance was deleted, restore the instance on the Backups page.	All databases and tables	A new instance An existing instance The original instance	Restoring a DB Instance from Backups
Restoring a deleted table	Use the database table restoration method to restore the table.	All databases and tables Some databases and tables	A new instance An existing instance The original instance	Restoring Tables to a Point in Time
Restoring a deleted database	Use the database table restoration method to restore the database.	All databases and tables Some databases and tables	A new instance An existing instance The original instance	Restoring Tables to a Point in Time
Restoring deleted or modified columns, rows, and data in tables, and overwritten tables	If more than 100,000 data records are deleted or modified, use the database table restoration method to restore data in the table.	All databases and tables Some databases and tables	A new instance An existing instance The original instance	Restoring Tables to a Point in Time