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