Do not read any option files. If program startup fails due to reading unknown options from an option file, –no-defaults can be used to prevent them from being read.
The exception is that the .mylogin.cnf file, if it exists, is read in all cases. This permits passwords to be specified in a safer way than on the command line even when –no-defaults is used. (.mylogin.cnf is created by the mysql_config_editor utility. See mysql_config_editor(1).)
/*!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 #161123 4:17:00 server id 1 end_log_pos 120 CRC32 0x095b60fa Start: binlog v 4, server v 5.6.27-0ubuntu0.14.04.1-log created 161123 4:17:00 BINLOG ' vKc0WA8BAAAAdAAAAHgAAAAAAAQANS42LjI3LTB1YnVudHUwLjE0LjA0LjEtbG9nAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAfpg Wwk= '/*!*/; # at 120 #161123 4:17:00 server id 1 end_log_pos 231 CRC32 0xbbec3fba Previous-GTIDs # 9dc1a422-aeb6-11e5-80cd-00163e001e5d:1-5846827, # fd076ada-69cf-11e6-84d8-00163e0c1dbe:1-381819 # at 231 #161123 4:17:00 server id 1 end_log_pos 279 CRC32 0x3f0812c4 GTID [commit=yes] SET @@SESSION.GTID_NEXT= '9dc1a422-aeb6-11e5-80cd-00163e001e5d:5846828'/*!*/; # at 279 #161123 4:17:00 server id 1 end_log_pos 353 CRC32 0x6982c05a Query thread_id=2662386 exec_time=0 error_code=0 SET TIMESTAMP=1479845820/*!*/; SET @@session.pseudo_thread_id=2662386/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1075838976/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8mb4 *//*!*/; SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=224/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; # at 353 #161123 4:17:00 server id 1 end_log_pos 450 CRC32 0xb1d11f47 Table_map: `linahr`.`qrtz_fired_triggers` mapped to number 877 # at 450 #161123 4:17:00 server id 1 end_log_pos 825 CRC32 0x0d1392a7 Update_rows: table id 877 flags: STMT_END_F
Reconstruct row events and display them as commented SQL statements. If this option is given twice, the output includes comments to indicate column data types and some metadata.
For examples that show the effect of –base64-output and –verbose on row event output, see the section called “MYSQLBINLOG ROW EVENT DISPLAY”.
This option determines when events should be displayed encoded as base-64 strings using BINLOG statements. The option has these permissible values (not case sensitive):
· AUTO (“automatic”) or UNSPEC (“unspecified”) displays BINLOG statements automatically when necessary (that is, for format description events and row events). If no –base64-output option is given, the effect is the same as –base64-output=AUTO.
Note
Automatic BINLOG display is the only safe behavior if you intend to use the output of mysqlbinlog to re-execute binary log file contents. The other option values are intended only for debugging or testing purposes because they may produce output that does not include all events in executable form.
· NEVER causes BINLOG statements not to be displayed. mysqlbinlog exits with an error if a row event is found that must be displayed using BINLOG.
· DECODE-ROWS specifies to mysqlbinlog that you intend for row events to be decoded and displayed as commented SQL statements by also specifying the –verbose option. Like NEVER, DECODE-ROWS suppresses display of BINLOG statements, but unlike NEVER, it does not exit with an error if a row event is found.
For examples that show the effect of –base64-output and –verbose on row event output, see the section called “MYSQLBINLOG ROW EVENT DISPLAY”.
SET TIMESTAMP=1479845826/*!*/; BEGIN /*!*/; # at 2697 #1611234:17:06 server id 1 end_log_pos 2773 CRC32 0x3b984e8d Table_map: `linahr_pay`.`qrtz_scheduler_state` mapped to number 1180 # at 2773 #1611234:17:06 server id 1 end_log_pos 2925 CRC32 0x394f0f8b Update_rows: table id 1180 flags: STMT_END_F ### UPDATE `linahr_pay`.`qrtz_scheduler_state` ### WHERE ### @1='CRMscheduler' ### @2='f5589e5e5a731477582086079' ### @3=1479845806492 ### @4=20000 ### SET ### @1='CRMscheduler' ### @2='f5589e5e5a731477582086079' ### @3=1479845826494 ### @4=20000 # at 2925 #1611234:17:06 server id 1 end_log_pos 2956 CRC32 0x7d1d1eab Xid = 447774290 COMMIT/*!*/;
--skip-gtids参数
–skip-gtids[=(true|false)]
Do not display any GTIDs in the output. This is needed when writing to a dump file from one or more binary logs containing GTIDs, as shown in this example: