直接查询
mysql> show binlog events in "mysql_binlog.000005";
使用工具查询
按时间查询
[root@db01 ~]# mysqlbinlog --start-datetime='2014-11-26 21:15:00' --stop-datetime='2014-11-26 21:35:00' -vv -d history /data/mysql/mysql_binlog.000005
按POS查询(ROW格式可以加-vv)
[root@db01 ~]# mysqlbinlog --start-position=200 --stop-position=600 -vv -d history /data/mysql/mysql_binlog.000005
mysql> show binlog events in "mysql_binlog.000005";
使用工具查询
按时间查询
[root@db01 ~]# mysqlbinlog --start-datetime='2014-11-26 21:15:00' --stop-datetime='2014-11-26 21:35:00' -vv -d history /data/mysql/mysql_binlog.000005
按POS查询(ROW格式可以加-vv)
[root@db01 ~]# mysqlbinlog --start-position=200 --stop-position=600 -vv -d history /data/mysql/mysql_binlog.000005