mysql基于binlog日志恢复中的疑问，求大神指点
0
悬赏园豆：40
[已关闭问题]
关闭于 2016-12-17 11:16
通过mysqlbinlog.exe将master-bin.000001转化成0001.sql存储起来，
打开0001.sql这个文件
里面没有的insert、update等语句都查看不到，都是形如以下格式的内容。（我想看执行了哪些语句）
1 #161003 5:55:00 server id 101 end_log_pos 1385 CRC32 0xc0869e41 Query thread_id=5710 exec_time=0 error_code=0 2 SET TIMESTAMP=1475445300/*!*/; 3 BEGIN 4 /*!*/; 5 # at 1385 6 #161003 5:55:00 server id 101 end_log_pos 1476 CRC32 0xdbf17752 Table_map: `kongchehui`.`driver_location` mapped to number 418 7 # at 1476 8 #161003 5:55:00 server id 101 end_log_pos 1652 CRC32 0x92be19ea Write_rows: table id 418 flags: STMT_END_F 9 10 BINLOG ' 11 NILxVxNlAAAAWwAAAMQFAAAAAKIBAAAAAAEACmtvbmdjaGVodWkAD2RyaXZlcl9sb2NhdGlvbgAM 12 CBIIBAQPDw8QDw8IDwAEBP0CYABgAAEAYABgAOIGUnfx2w== 13 NILxVx5lAAAAsAAAAHQGAAAAAKIBAAAAAAEAAgAM//8A8BJkRgAAAAAAmZqGXZ7PNwAAAAAAABqv 14 ykH6lOxCPwDnpo/lu7rnnIHms4nlt57luILmsLjmmKXljr/pgJrotKTot6/pnaDov5HmsLjmmKXn 15 oqfmoYLlm63pmYTov5EJ5rOJ5bee5biCCeawuOaYpeWOvwEEV0lGSQnnpo/lu7rnnIEAAAAAAAAA 16 AOoZvpI= 17 '/*!*/; 18 # at 1652 19 #161003 5:55:00 server id 101 end_log_pos 1743 CRC32 0xbdcea371 Table_map: `kongchehui`.`driver_location` mapped to number 418 20 # at 1743 21 #161003 5:55:00 server id 101 end_log_pos 1919 CRC32 0x774f0423 Write_rows: table id 418 flags: STMT_END_F 22 23 BINLOG ' 24 NILxVxNlAAAAWwAAAM8GAAAAAKIBAAAAAAEACmtvbmdjaGVodWkAD2RyaXZlcl9sb2NhdGlvbgAM 25 CBIIBAQPDw8QDw8IDwAEBP0CYABgAAEAYABgAOIGcaPOvQ== 26 NILxVx5lAAAAsAAAAH8HAAAAAKIBAAAAAAEAAgAM//8A8BNkRgAAAAAAmZqGXbRtOQAAAAAAAGi6 27 xUFoRexCPwDnpo/lu7rnnIHljqbpl6jluILlkIzlronljLrnjq/ln47opb/ot6/pnaDov5HlsbHn 28 lLDpmLLmsLTpmYTov5EJ5Y6m6Zeo5biCCeWQjOWuieWMugAEV0lGSQnnpo/lu7rnnIEAAAAAAAAA 29 ACMET3c= 30 '/*!*/; 31 # at 1919
