MySQL database recovers data through Bin-log logs

Binlog logs are used to record all update data, and when our database fails, we can use the Binlog log to retrieve it.

If there is a problem with the MySQL database, you need to recreate the Binlog binary file.

# 查看日志，查出需要恢复的时间点mysqlbinlog --no-defaults fangx-bin.000001 |more

#恢复具体时间导成SQL语句mysqlbinlog fangx-bin.000001 --database=fangx --start-datetime=‘2018-06-6 00:00:01‘ --stop-datetime=‘2018-06-6 23:59:59‘   > fangx2018.sql

database   #为要恢复的数据库名称 start-datetime   #恢复的起始时间 stop-datetime   #恢复的结束时间

# 把sql语句导入进去mysql -uroot -pfan fangx -v -f < fangx2018.sql-v   是查看导入的详细信息-f   是当中间遇到错误时，可以skip过去，继续执行下面的语句

# 或者这样直接导入mysqlbinlog --no-defaults fangx-bin.000001 --start-position="794" --stop-position="1055" | mysql -uroot -pfan fangx

 #清除所有binlog日志 从1开始 reset master

MySQL database recovers data through Bin-log logs