误删除binlog恢复

mysqlbinlog --base64-output=DECODE-ROWS -v --start-datetime="2021-05-25 21:50:00" --stop-datetime="2021-05-25 21:56:00" /opt/mysql/log/mysql3306-bin.000093

cat 111.sql | sed -n '/# at 200939316/,/COMMIT/p' | sed 's/### //g;s/\/\*.*/,/g;s/DELETE FROM/\;INSERT INTO/g;s/WHERE/SELECT/g;' |sed -r 's/(@21.*),/\1;/g' | sed 's/@1=//g' | sed 's/@[1-9]=/,/g' | sed 's/@[1-9][0-9]=/,/g' > 222.sql

python Binlong2sql