Recovery work after MySQL database is deleted

The morning accidentally put a database that was just built yesterday to delete all naked! Fortunately, MySQL turned on the log function.

Here's a summary of the recovery methods after the database is deleted:

First: Save the most recent binary type log file as a text file for export, with the following command:

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

Second: Open the saved TXT file, the file format is as follows:

where at 1099 represents the 1099th command (so to speak), query these commands, see where you need to reply to the command, and then execute command.

Finally: Execute the reply command as follows:

mysqlbinlog--start-position= "123"--stop-position= "531" f:/wamp/mysql-bin.000045 F:/test.txt | mysql-uroot-p< /c5>

This will be able to complete the database reply!!!