mysql 数据恢复

mysqlbinlog --no-defaults --base64-output=decode-rows -v --database=volunteer-service --start-datetime="2020-09-18 16:00:00" --stop-datetime="2020-09-18 17:00:00" //var/lib/mysql/binlog.000004 -r test4.sql

cat test4.sql | sed -n '/###/p' | sed 's/### //g;s//*.*/,/g;s/DELETE FROM/;INSERT INTO/g;s/WHERE/SELECT/g;' |sed -r 's/(@17.*),/1;/g' | sed 's/@1=//g'| sed 's/@[1-9]=/,/g' | sed 's/@[1-9][0-9]=/,/g' > mysqllogOK.sql

原文地址:https://www.cnblogs.com/fkeyta/p/13695904.html