mysqlbinlog使用

通过 mysqlbinlog 和 grep 命令定位binlog文件中指定操作
/usr/local/mysql/bin/mysqlbinlog --no-defaults --base64-output=decode-rows -v /usr/local/mysql/var/mysql-bin.000009 | grep -i -A 10 -B 10 '字符串'

 

导出指定数据表的sql

/usr/local/mysql/bin/mysqlbinlog --start-datetime="2022-06-16 16:00:00" --stop-datetime="2022-06-18 18:00" mysql-bin.000032 -d shuangchuang|grep '`sc_works_expert`' > aaaaaa.sql

 

基于开始/结束时间：
mysqlbinlog --start-datetime="2017-09-17 07:21:09" --stop-datetime="2017-09-19 07:59:50" mysql-bin.000002

基于pos值：
mysqlbinlog --start-position=205 --stop-position=2205 mysql-bin.000002

 

 

 

参考资料：

https://blog.csdn.net/XiaoXiao_RenHe/article/details/77983280

https://wenku.baidu.com/view/6cb193ea8aeb172ded630b1c59eef8c75fbf9598.html

https://www.jianshu.com/p/51512d7bf092

https://www.kancloud.cn/wenshunbiao/wenshunbiao/1403850