查看mysql路径
show variables like '%dir%';
show master logs;
cd 到mysql安装目录的bin目录底下去执行
cd C:\Program Files\MySQL\MySQL Server 5.7\bin
根据时间范围导出日志
mysqlbinlog --no-defaults --start-datetime="2018-04-28 00:00:00" --stop-datetime="2018-04-28 23:59:59" "C:\ProgramData\MySQL\MySQL Server 5.5\data/mysql-bin.000027" --result-file=d:/222.sql;