基于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密码