SET TIMESTAMP=1459999601/*!*/; BEGIN /*!*/; # at 301 #160407 11:26:41 server id 10 end_log_pos 346 Table_map: `test`.`tb1` mapped to number 224 # at 346 #160407 11:26:41 server id 10 end_log_pos 395 Write_rows: table id 224 flags: STMT_END_F
BINLOG ' cdMFVxMKAAAALQAAAFoBAAAAAOAAAAAAAAEABHRlc3QAA3RiMQACAw8CFAAD cdMFVx4KAAAAMQAAAIsBAAAAAOAAAAAAAAEAAgAC//wBAAAAA2FhYfwCAAAAA2FhYQ== '/*!*/; ### INSERT INTO `test`.`tb1` ### SET ### @1=1 ### @2='aaa' ### INSERT INTO `test`.`tb1` ### SET ### @1=2 ### @2='aaa' # at 395 #160407 11:26:41 server id 10 end_log_pos 422 Xid = 271 COMMIT/*!*/; # at 422 #160407 11:27:04 server id 10 end_log_pos 490 Query thread_id=5 exec_time=0 error_code=0 SET TIMESTAMP=1459999624/*!*/; BEGIN /*!*/; # at 490 #160407 11:27:04 server id 10 end_log_pos 535 Table_map: `test`.`tb1` mapped to number 224 # at 535 #160407 11:27:04 server id 10 end_log_pos 575 Delete_rows: table id 224 flags: STMT_END_F
BINLOG ' iNMFVxMKAAAALQAAABcCAAAAAOAAAAAAAAEABHRlc3QAA3RiMQACAw8CFAAD iNMFVyAKAAAAKAAAAD8CAAAAAOAAAAAAAAEAAgAC//wCAAAAA2FhYQ== '/*!*/; ### DELETE FROM `test`.`tb1` ### WHERE ### @1=2 ### @2='aaa' # at 575 #160407 11:27:04 server id 10 end_log_pos 602 Xid = 272 COMMIT/*!*/; # at 602 #160407 11:27:22 server id 10 end_log_pos 670 Query thread_id=5 exec_time=0 error_code=0 SET TIMESTAMP=1459999642/*!*/; BEGIN /*!*/; # at 670 #160407 11:27:22 server id 10 end_log_pos 715 Table_map: `test`.`tb1` mapped to number 224 # at 715 #160407 11:27:22 server id 10 end_log_pos 765 Update_rows: table id 224 flags: STMT_END_F
BINLOG ' mtMFVxMKAAAALQAAAMsCAAAAAOAAAAAAAAEABHRlc3QAA3RiMQACAw8CFAAD mtMFVx8KAAAAMgAAAP0CAAAAAOAAAAAAAAEAAgAC///8AQAAAANhYWH8AQAAAANiYmI= '/*!*/; ### UPDATE `test`.`tb1` ### WHERE ### @1=1 ### @2='aaa' ### SET ### @1=1 ### @2='bbb' # at 765 #160407 11:27:22 server id 10 end_log_pos 792 Xid = 273 COMMIT/*!*/; # at 792 #160407 11:28:04 server id 10 end_log_pos 829 Rotate to 128.000130 pos: 4 DELIMITER ;
+------+------+ | id | name | +------+------+ | 1 | bbb | +------+------+
mysqlbinlog -v --start-pos=557 128.000132
#####################
# at 557 #160407 12:04:15 server id 10 end_log_pos 602 Table_map: `test`.`tb1` mapped to number 224 # at 602 #160407 12:04:15 server id 10 end_log_pos 652 Update_rows: table id 224 flags: STMT_END_F
BINLOG ' P9wFVxMKAAAALQAAAFoCAAAAAOAAAAAAAAEABHRlc3QAA3RiMQACAw8CFAAD P9wFVx8KAAAAMgAAAIwCAAAAAOAAAAAAAAEAAgAC///8AQAAAANhYWH8AQAAAANiYmI= '/*!*/; ### UPDATE `test`.`tb1` ### WHERE ### @1=1 ### @2='aaa' ### SET ### @1=1 ### @2='bbb' # at 652 #160407 12:04:15 server id 10 end_log_pos 679 Xid = 540 COMMIT/*!*/;
#####################
mysqlbinlog -v -B --start-pos=557 128.000132
############################
BINLOG ' P9wFVxMKAAAALQAAAFoCAAAAAOAAAAAAAAEABHRlc3QAA3RiMQACAw8CFAAD P9wFVx8KAAAAMgAAAIwCAAAAAOAAAAAAAAEAAgAC///8AQAAAANiYmL8AQAAAANhYWE= '/*!*/; ### UPDATE `test`.`tb1` ### WHERE ### @1=1 ### @2='bbb' ### SET ### @1=1 ### @2='aaa'
############################
可以看出update已经被反转
执行反转
mysqlbinlog -B -v --start-pos=557 128.000132 | mysql -utest -ptest test
mysql> select * from tb1; +------+------+ | id | name | +------+------+ | 1 | aaa | +------+------+