Restore a deleted MySQL database

Restore a deleted MySQL database

In the morning, I accidentally deleted a database I just created yesterday! Fortunately, the log feature is enabled in mysql.

The following describes how to restore a deleted database:

First, save the most recent binary log files as text files and export them. The command is as follows:

Mysqlbinlog F:/wamp/mysql-bin.000045> F:/test.txt

Second, open the saved txt file in the following format:

Here, at 1099 represents 1,099th commands (Let's note). query these commands to see where the command you want to reply is and then execute the command.

Finally, execute the reply Command, as shown below:

Mysqlbinlog -- start-position = "123" -- stop-position = "531" F:/wamp/mysql-bin.000045 F:/test.txt "mysql-uroot-p

In this way, you can complete the database reply !!!