mysql 日志恢复
shows master logs
flush logs
将日志转为sql文件:
mysqlbinlog --no-defaults --base64-output=decode-rows -v --start-datetime="2021-04-10 14:59:00" --stop-datetime="2021-04-10 15:00:00" mysql-bin.000061 > test.sql
shows master logs
flush logs
将日志转为sql文件:
mysqlbinlog --no-defaults --base64-output=decode-rows -v --start-datetime="2021-04-10 14:59:00" --stop-datetime="2021-04-10 15:00:00" mysql-bin.000061 > test.sql
