[root@zjzc01 binlog]# mysqlbinlog --start-datetime='2016-02-25 00:00:00' --stop-datetime='2016-03-15 17:00:00' mysql-bin.000023 mysql-bin.000024 >a.txt
[root@zjzc01 binlog]# head -20 a.txt
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#160218 13:19:00 server id 135 end_log_pos 120 CRC32 0x67689bc5 Start: binlog v 4, server v 5.6.22-log created 160218 13:19:00
BINLOG '
RFTFVg+HAAAAdAAAAHgAAAAAAAQANS42LjIyLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAcWb
a
mysqlbinlog 读取多个文件
最新推荐文章于 2023-09-01 11:09:20 发布
本文演示了如何使用mysqlbinlog工具指定开始和结束日期时间,从多个MySQL binlog文件中提取日志内容,并将结果重定向到一个文本文件。示例命令显示了如何读取mysql-bin.000023和mysql-bin.000024文件,并过滤出特定时间范围的日志。
摘要由CSDN通过智能技术生成