过滤出DELETE语句(按需添加时间戳筛选)

/usr/local/mysql/bin/mysqlbinlog --no-defaults --base64-output=decode-rows -v -v mysql-bin.000221 |sed -n '/### DELETE FROM `datacloud_base_pro`.`t_dc_web_menu`/,/COMMIT/p' > t_dc_web_menu.txt

反写出回滚语句

cat t_dc_web_menu.txt | sed -n '/###/p' | sed 's/### //g;s/\/\*.*/,/g;s/DELETE FROM/INSERT INTO/g;s/WHERE/SELECT/g;' | sed -r 's/(@19.*),/\1;/g' | sed 's/@[1-9]=//g' > recover_t_dc_web_menu.sql