mysql-bin position_mysqlbinlog基于某个偏移量进行数据的恢复(重做),--start-position,--stop-position的使用方法...

需求描述:

今天在看mysqlbinlog的内容,看到了--start-position和--stop-position这些选项,

就测试下这个参数具体该怎么进行使用呢,在此记录下.

操作过程:

1.通过mysqlbinlog以文本的格式查看某个binlog的内容

[mysql@redhat6 data]$mysqlbinlog mysql-bin.000027 | more

/*!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/*!*/;

# at4#180410 17:57:32 server id 1 end_log_pos 107 Start: binlog v 4, server v 5.5.57-log created 180410 17:57:32BINLOG'jIrMWg8BAAAAZwAAAGsAAAAAAAQANS41LjU3LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAVAAEGggAAAAICAgCAA==

'/*!*/;

# at 107#180410 17:57:32 server id 1 end_log_pos 180 Query thread_id=89 exec_time=0 error_code=0SET TIMESTAMP=1523354252/*!*/;

SET