1.查看最新的binlog状态:
show master status;
2.查看具体的binlog文件:
show binlog events in "mysql-bin.000004" from 154 limit 2,2\G (注意没有分号)
3.产生新的日志文件:
flush logs;
4.重置日志,删除所有日志文件:
reset master;
5.还原数据库数据:
D:\mysql-5.7.28-winx64\bin>mysqlbinlog --start-position=154 --stop-position=427 "D:\mysql-5.7.28-winx64\data\binlog\mysql-bin.000001" -d test1 | mysql -u root -p
6.还原数据库数据(禁止产生日志):
mysqlbinlog --start-position=154 --stop-position=427 -D "D:\mysql-5.7.28-winx64\data\binlog\mysql-bin.000001" -d test2 | mysql -u root -p
7.以sql形式展示binlog:
mysqlbinlog --no-defaults --database=test2 --base64-output=decode-rows -v --start-position=154 --stop-position=427 D:\mysql-5.7.28-winx64\data\binlog\mysql-bin.000001
8.以sql形式展示binlog到文件:
mysqlbinlog --no-defaults --database=test2 --base64-output=decode-rows -v --start-position=154 --stop-position=427 D:\mysql-5.7.28-winx64\data\binlog\mysql-bin.000001 > 2.sql
9.根据时间区间查询binlog到文件:
mysqlbinlog --no-defaults --database=test2 --base64-output=decode-rows -v --start-datetime="2019-10-15 00:00:00" --stop-datetime="2019-10-16 00:00:00" D:\mysql-5.7.28-winx64\data\binlog\mysql-bin.000001 > 2.sql