mysql binlog 读取_mysqlbinlog 读取多个文件

[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

aGc=

'/*!*/;

# at 245349610

#160225 0:00:00 server id 135 end_log_pos 245349693 CRC32 0x762d1c6b Querythread_id=2254718exec_time=0error_code=0

SET TIMESTAMP=1456329600/*!*/;

SET @@session.pseudo_thread_id=2254718/*!*/;

SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;

SET @@session.sql_mode=1075838976/*!*/;

SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;

/*!\C utf8 *//*!*/;

SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;

[root@zjzc01 binlog]# tail -20 a.txt

#160315 16:59:57 server id 135 end_log_pos 469446594 CRC32 0xfca1ebec Xid = 150307531

COMMIT/*!*/;

# at 469446594

#160315 16:59:58 server id 135 end_log_pos 469446677 CRC32 0x567724fa Querythread_id=2676924exec_time=0error_code=0

SET TIMESTAMP=1458032398/*!*/;

BEGIN

/*!*/;

# at 469446677

#160315 16:59:58 server id 135 end_log_pos 469446891 CRC32 0xc7e1524e Querythread_id=2676924exec_time=0error_code=0

SET TIMESTAMP=1458032398/*!*/;

UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1458032398648 WHERE SCHED_NAME = 'ReportControlScheduler' AND INSTANCE_NAME = 'auto'

/*!*/;

# at 469446891

#160315 16:59:58 server id 135 end_log_pos 469446922 CRC32 0xdb534e04 Xid = 150307543

COMMIT/*!*/;

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;

/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

[root@zjzc01 binlog]#