Data recovery for MySQL via Bin-log

mysqlbinlog --database= database name--start-date= "2017-06-01 5:00:00"--stop-date= "2017-06-11 10:00:00" var/ mysql-bin.000001 | MySQL -u root-p123456-f

1, note the location of the bold Word executable file, if you have added environment variables can be ignored

2, note the red character Bin-log log location to write to

3, the database name to change

4, you can set the date

5, the last set up the use of the database account, password

Data recovery for MySQL via Bin-log