RDS Database file backup restore __ Database

Objective

A few days ago to do data updates, the hand shook a bit, the data deleted. Fortunately Aliyun has 7 days of backup, immediately downloaded the backup file, want to back up. Refer to Official Backup recovery workaround: https://help.aliyun.com/knowledge_detail/41817.html?spm=5176.11065259.1996646101. Searchclickresult.569d1aa3t4iuzc. Feel very cumbersome. There is no simpler way to recover data. The following methods are currently used for simplicity and ease of use. Backup Recovery

After you extract the backup files from the RDS download, you will get a file of. ibd and. frm. such as USER.FRM,USER.IBD. If you want to restore the user table, do the following: Build a table that is exactly the same as the user's field. To view the local data directory (Windows is typically under the data path of your MySQL installation directory), there will be USER.FRM,USER.IBD execute ALTER TABLE user discard tablespace. Deletes the local user.ibd file to perform the ALTER TABLE user import tablespace by copying the backup USER.IBD to local user. Lesson

Don't shake your hands.