mysql二进制文件恢复为sql

/usr/bin/mysqlbinlog --no-defaults --database=oop --base64-output=DECODE-ROWS -v /var/lib/mysql/testdb-bin.000018 > /testdb18.txt

/usr/bin/mysqlbinlog --skip-gtids -vv --database=sshl --base64-output=decode-rows --start-datetime=‘2023-05-18 12:00:00’ --stop-datetime=‘2023-05-18 16:00:00’ /opt/smartby/app/mysql/data/mysql-bin.000001 /opt/smartby/app/mysql/data/mysql-bin.000002 /opt/smartby/app/mysql/data/mysql-bin.000003 /opt/smartby/app/mysql/data/mysql-bin.000004 > 1.log

mysqlbinlog.exe --no-defaults --database=oop --base64-output=DECODE-ROWS -v E:/mysql二进制文件恢复为sql/mysql-bin.000007 >E:/mysql二进制文件恢复为sql/07-1.txt

mysqlbinlog.exe --no-defaults --database=oop --base64-output=DECODE-ROWS -v E:/mysql二进制文件恢复为sql/1.log>E:/mysql二进制文件恢复为sql/01.txt

mysqlbinlog.exe --skip-gtids -vv --database=sshl --base64-output=decode-rows E:/mysql-bin.000001 > E:/mysql二进制文件恢复为sql/1.txt

mysqlbinlog.exe --skip-gtids -vv --database=sshl --base64-output=decode-rows E:/mysql-bin.000002 > E:/mysql二进制文件恢复为sql/2.txt

mysqlbinlog.exe --skip-gtids -vv --database=sshl --base64-output=decode-rows E:/mysql-bin.000003 > E:/mysql二进制文件恢复为sql/3.txt