Edit File: binlog_hexdump.result
/*!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 #111118 13:10:33 server id 1 end_log_pos 114 # Position Timestamp Type Master ID Size Master Pos Flags # 4 19 2f c6 4e 0f 01 00 00 00 6e 00 00 00 72 00 00 00 00 00 # 17 04 00 35 2e 36 2e 34 2d 6d 37 2d 64 65 62 75 67 |..5.6.4.m7.debug| # 27 2d 6c 6f 67 00 00 00 00 00 00 00 00 00 00 00 00 |.log............| # 37 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| # 47 00 00 00 00 19 2f c6 4e 13 38 0d 00 08 00 12 00 |.......N.8......| # 57 04 04 04 04 12 00 00 56 00 04 1a 08 00 00 00 08 |.......V........| # 67 08 08 02 00 00 00 00 ba 38 4d f8 |........8M.| # Start: binlog v 4, server v 5.6.4-m7-debug-log created 111118 13:10:33 at startup ROLLBACK/*!*/; BINLOG ' GS/GTg8BAAAAbgAAAHIAAAAAAAQANS42LjQtbTctZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAZL8ZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAALo4Tfg= '/*!*/; # at 114 #111118 13:11:28 server id 1 end_log_pos 245 # Position Timestamp Type Master ID Size Master Pos Flags # 72 50 2f c6 4e 02 01 00 00 00 83 00 00 00 f5 00 00 00 00 00 # 85 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................| # 95 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std| # a5 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te| # b5 73 74 00 44 52 4f 50 20 54 41 42 4c 45 20 49 46 |st.DROP.TABLE.IF| # c5 20 45 58 49 53 54 53 20 60 74 31 30 31 32 33 34 |.EXISTS..t101234| # d5 35 36 37 38 39 60 20 2f 2a 20 67 65 6e 65 72 61 |56789.....genera| # e5 74 65 64 20 62 79 20 73 65 72 76 65 72 20 2a 2f |ted.by.server...| # Query thread_id=1 exec_time=0 error_code=0 use `test`/*!*/; SET TIMESTAMP=1321611088/*!*/; SET @@session.pseudo_thread_id=1/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=0/*!*/; 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=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; DROP TABLE IF EXISTS `t10123456789` /* generated by server */ /*!*/; # at 245 #111118 13:11:48 server id 1 end_log_pos 347 # Position Timestamp Type Master ID Size Master Pos Flags # f5 64 2f c6 4e 02 01 00 00 00 66 00 00 00 5b 01 00 00 00 00 # 108 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................| # 118 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std| # 128 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te| # 138 73 74 00 63 72 65 61 74 65 20 74 61 62 6c 65 20 |st.create.table.| # 148 74 31 30 31 32 33 34 35 36 37 38 39 28 69 20 69 |t10123456789.i.i| # 158 6e 74 29 |nt.| # Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1321611108/*!*/; create table t10123456789(i int) /*!*/; # at 347 #111118 13:12:21 server id 1 end_log_pos 422 # Position Timestamp Type Master ID Size Master Pos Flags # 15b 85 2f c6 4e 02 01 00 00 00 4b 00 00 00 a6 01 00 00 08 00 # 16e 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................| # 17e 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std| # 18e 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te| # 19e 73 74 00 42 45 47 49 4e |st.BEGIN| # Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1321611141/*!*/; BEGIN /*!*/; # at 422 # at 447 #111118 13:12:21 server id 1 end_log_pos 447 # Position Timestamp Type Master ID Size Master Pos Flags # 1a6 85 2f c6 4e 0e 01 00 00 00 19 00 00 00 bf 01 00 00 00 00 # 1b9 01 00 00 00 32 01 |....2.| # User_var SET @`2`:=NULL/*!*/; #111118 13:12:21 server id 1 end_log_pos 552 # Position Timestamp Type Master ID Size Master Pos Flags # 1bf 85 2f c6 4e 02 01 00 00 00 69 00 00 00 28 02 00 00 00 00 # 1d2 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................| # 1e2 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std| # 1f2 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te| # 202 73 74 00 69 6e 73 65 72 74 20 69 6e 74 6f 20 74 |st.insert.into.t| # 212 31 30 31 32 33 34 35 36 37 38 39 20 76 61 6c 75 |10123456789.valu| # 222 65 73 28 40 32 29 |es..2.| # Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1321611141/*!*/; insert into t10123456789 values(@2) /*!*/; # at 552 #111118 13:12:21 server id 1 end_log_pos 579 # Position Timestamp Type Master ID Size Master Pos Flags # 228 85 2f c6 4e 10 01 00 00 00 1b 00 00 00 43 02 00 00 00 00 # 23b 0a 00 00 00 00 00 00 00 |........| # Xid = <number> COMMIT/*!*/; # at 579 #111118 13:12:33 server id 1 end_log_pos 710 # Position Timestamp Type Master ID Size Master Pos Flags # 243 91 2f c6 4e 02 01 00 00 00 83 00 00 00 c6 02 00 00 00 00 # 256 01 00 00 00 00 00 00 00 04 00 00 21 00 00 00 00 |................| # 266 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std| # 276 04 21 00 21 00 08 00 0c 01 74 65 73 74 00 74 65 |.........test.te| # 286 73 74 00 44 52 4f 50 20 54 41 42 4c 45 20 49 46 |st.DROP.TABLE.IF| # 296 20 45 58 49 53 54 53 20 60 74 31 30 31 32 33 34 |.EXISTS..t101234| # 2a6 35 36 37 38 39 60 20 2f 2a 20 67 65 6e 65 72 61 |56789.....genera| # 2b6 74 65 64 20 62 79 20 73 65 72 76 65 72 20 2a 2f |ted.by.server...| # Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1321611153/*!*/; DROP TABLE IF EXISTS `t10123456789` /* generated by server */ /*!*/; # at 710 #111118 13:12:41 server id 1 end_log_pos 729 # Position Timestamp Type Master ID Size Master Pos Flags # 2c6 99 2f c6 4e 03 01 00 00 00 13 00 00 00 d9 02 00 00 00 00 # Stop DELIMITER ; # End of log file ROLLBACK /* added by mysqlbinlog */; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;