mysql 逻辑恢复 误删恢复 redo&&undo

网盘下载 mysqlbinlog工具，该工具由阿里工程师开发，或者在 mariadb版本的 安装目录下，找到mysqlbinlog 工具
mv /usr/local/mysql/bin/mysqlbinlog /usr/local/mysql/bin/mysqlbinlog.bak

替换官方的mysqlbinlog
cp /root/mysqlbinlog /usr/local/mysql/bin/mysqlbinlog
chown -R mysql:mysql /usr/local/mysql/bin/mysqlbinlog
chmod 755 /usr/local/mysql/bin/mysqlbinlog

查看当前版本是否支持flashback功能
/usr/local/mysql/bin/mysqlbinlog --help |grep flashback

#生成undo 回滚sql文件   自行根据--help 指引操作
/usr/local/mysql/bin/mysqlbinlog -vv /u01/mysqllog/logbin.000003 -B > undo.sql