截取:
基本语法:
mysqlbinlog --base64-output=decode-rows -v /binlog/mysqlbin.000039 |more > /tmp/39.sql
带起止号的
myslqbinlog --base64-output=decode-rows -v --start-position=.... --stop-position=.... /binlog/mysqlbin.000039> /tmp/both118.sql
所有的
mysqlbinlog --base64-output=decode-rows -v /binlog/mysqlbin.000039 |more > /tmp/39.sql
基于时间截取:
mysqlbinlog --no-defaults -vv --base64-output=decode-rows --start-datetime='2020-08-18 11:20:00' --stop-datetime='2020-08-18 12:00:00' mysql-bin.000203 mysql-bin.000204 mysql-bin.000205
mysqlbinlog --base64-output=decode-rows -v --start-datetime="2021-11-15 9:00:00" --stop-datetime="2021-11-15 9:50:00" /binlog/mysqlbin.000095 |more > /tmp/both118.sql
筛选:
grep -B1 -A1 -w 'boyuan.zheng' /tmp/39.sql >/tmp/39grep.sql
-B:before(前多少行) -A:after(后多少行)
-W‘、