环境: windows、 mysql8.0.13
- 查看binlog信息
show variables like '%log_bin%';
- 通过mysqlbinlog将binlog转为sql文件
mysqlbinlog --start-datetime="2020-05-31 00:00:00" --stop-datetime="2020-05-31 15:00:00" "./binlog.000001" > binlog000001.sql
- 数据恢复
source binlog000001.sql