基于mysqlbinlog恢复数据

1、把binlog转换为SQL

mysqlbinlog --base64-output=decode-rows -vv  /usr/local/mysql/log-bin/mysql-bin.000003 >result.sql
find / -name result.sql

2、查看events

show binlog events in 'mysql-bin.000003';

3、回滚到3667那一行的数据

mysqlbinlog -v /usr/local/mysql/log-bin/mysql-bin.000003 --stop-position=3667 | mysql -uroot -p密码