Restoration Methods

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

Restoring or Migrating Data to TaurusDB

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 Data from Common 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. You can choose an appropriate data restoration method as required.

**Table 1** Restoration methods for misoperations
Scenario	Restoration Method	Restoration Scope	Restore To	Operation Guide
Restoring a deleted instance	If the deleted instance is in the recycle bin, rebuild it from 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 (PITR)
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 (PITR)
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 (PITR)

Parent Topic: Data Restorations

Previous topic: Data Restorations

Next topic: Restoring a DB Instance from Backups

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

For any further questions, feel free to contact us through the chatbot.

Chatbot