- 论坛徽章:
- 1
|
本帖最后由 xinglu1983 于 2015-06-30 21:06 编辑
从阿里云云数据库rds上下载了binlog,使用命令:- mysqlbinlog -v --base64-output=decode-rows -d dbname mysql-bin.000800 > test.sql
复制代码 打开后,发现test.sql里凡是insert update语句全是注释状态?这样执行source肯定是不成功的吧,是我使用方式不对吗?
跪求答复~- /*!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
- #150623 21:10:10 server id 1154825058 end_log_pos 120 CRC32 0xc2bbe735 Start: binlog v 4, server v 5.6.16-log created 150623 21:10:10
- # at 120
- #150623 21:10:10 server id 1154825058 end_log_pos 231 CRC32 0x7ca67fb2 Previous-GTIDs
- # 648e928c-c587-11e4-903f-ac162d89fd88:1-88450260,
- # 72f39443-c587-11e4-903f-ac162d8aa4a4:1-6811
- # at 231
- #150623 21:10:14 server id 1065724891 end_log_pos 279 CRC32 0x515d2478 GTID [commit=yes]
- SET @@SESSION.GTID_NEXT= '648e928c-c587-11e4-903f-ac162d89fd88:88450261'/*!*/;
- # at 279
- #150623 21:10:14 server id 1065724891 end_log_pos 342 CRC32 0xe3592098 Query thread_id=8124091 exec_time=0 error_code=0
- SET TIMESTAMP=1435061414/*!*/;
- SET @@session.pseudo_thread_id=8124091/*!*/;
- SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
- SET @@session.sql_mode=524288/*!*/;
- 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=33/*!*/;
- SET @@session.lc_time_names=0/*!*/;
- SET @@session.collation_database=DEFAULT/*!*/;
- BEGIN
- /*!*/;
- # at 342
- #150623 21:10:14 server id 1065724891 end_log_pos 404 CRC32 0x8a7c8cf6 Table_map: `mysql`.`ha_health_check` mapped to number 755912
- # at 404
- #150623 21:10:14 server id 1065724891 end_log_pos 460 CRC32 0xccd8cdcb Update_rows: table id 755912 flags: STMT_END_F
- ### UPDATE `mysql`.`ha_health_check`
- ### WHERE
- ### @1=1435061404168
- ### @2='m'
- ### SET
- ### @1=1435061414704
- ### @2='m'
- # at 460
- #150623 21:10:14 server id 1065724891 end_log_pos 491 CRC32 0x4f517162 Xid = 102721104
- COMMIT/*!*/;
- # at 491
- #150623 21:10:25 server id 1065724891 end_log_pos 539 CRC32 0xce1bc682 GTID [commit=yes]
- SET @@SESSION.GTID_NEXT= '648e928c-c587-11e4-903f-ac162d89fd88:88450262'/*!*/;
- # at 539
- #150623 21:10:25 server id 1065724891 end_log_pos 602 CRC32 0x8004c9b6 Query thread_id=8124116 exec_time=0 error_code=0
- SET TIMESTAMP=1435061425/*!*/;
- BEGIN
- /*!*/;
- # at 602
- #150623 21:10:25 server id 1065724891 end_log_pos 664 CRC32 0x535bfa0a Table_map: `mysql`.`ha_health_check` mapped to number 755912
- # at 664
- #150623 21:10:25 server id 1065724891 end_log_pos 720 CRC32 0x47d0558a Update_rows: table id 755912 flags: STMT_END_F
- ### UPDATE `mysql`.`ha_health_check`
- ### WHERE
- ### @1=1435061414704
- ### @2='m'
- ### SET
- ### @1=1435061425308
- ### @2='m'
- # at 720
- #150623 21:10:25 server id 1065724891 end_log_pos 751 CRC32 0xb26e12cd Xid = 102721160
- COMMIT/*!*/;
复制代码
test.zip
(11.82 KB, 下载次数: 3)
|
|