mysqlbinlog相关

1.输出binlog到文件
mysqlbinlog --base64-output=decode-rows -v /home/mysql/binlog/binlog.000011>/tmp/aa.txt

2.查看某个pos后的多少行
show binlog events IN 'binlog.000011' FROM 686264000 LIMIT 100;

posted @ 2019-01-25 09:02  slnngk  阅读(135)  评论(0编辑  收藏  举报