MySQL误delete删除数据后 从binlog恢复方法

mysqlbinlog --no-defaults --base64-output=decode-rows -v -v ./binlog.000017 > mysql_bin_log.txt


cat mysql_bin_log.txt | sed -n '/### DELETE FROM `huamaopay`.`hmp_order`/,/COMMIT/p' > table_delete.txt



cat table_delete.txt | sed -n '/###/p' | sed 's/### //g;s/\/\*.*/,/g;s/DELETE FROM/INSERT INTO/g;s/WHERE/SELECT/g;' | sed -r 's/(@26.*),/\1;/g' | sed 's/@.*=//g' > /home/ubuntu/recovery.sql