Tutorial for Mysql data recovery

一、 Database Rollback

To perform a database rollback, it is necessary to ensure that both the data backup file and the binlog are available. Then it can recover to any second within the last 7 days.

Check the data in the tables of the target database.

Enable MySQL backup as instructed in the images above.

Modify the data in the table.

Through the above operations, restore the data of the table 'user' in the database 'leez' to the state at 14:13:08 on 2025-1-20 (i.e., ten minutes ago).

A new database 'leez_1737353588_1737354425' has appeared, which represents the state of the 'leez' database at 14:13:08 on 2025-1-20. This indicates that the database recovery was successful, and the source database will not be overwritten.

二、 Create Database from Backup

Select the backup file that has already been created, then click "Create from Backup".

After selecting the configurations, click "Purchase Now."

Check the data in the newly created database from the backup, which reflects the state at the time the backup was created, indicating a successful recovery.