首页 新闻 赞助 找找看

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

 

 

王大仙¥的主页 王大仙¥ | 初学一级 | 园豆:162
提问于:2016-10-10 16:02
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册