MySQL binlog指定时间恢复数据

查看最近的binlog日志

 show master status\G;

查看所有的binlog日志

show master logs;

指定时间点恢复数据 ----->导出为sql文件

 /usr/local/mysql/bin/mysqlbinlog  /usr/local/mysql/var/mysql-bin.000008 --start-datetime='2020-05-29 09:00:00' --stop-datetime='2020-05-29 11:00:00' -r ./a.sql