Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.118.31.32
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
binlog /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
binlog_anonymous_ownership.res...
15.33
KB
-rw-r--r--
binlog_bug23533.result
486
B
-rw-r--r--
binlog_bug36391.result
143
B
-rw-r--r--
binlog_cache_write_failure.res...
2.4
KB
-rw-r--r--
binlog_check_flush_log_asserti...
595
B
-rw-r--r--
binlog_checksum.result
697
B
-rw-r--r--
binlog_crash_safe_master_check...
1.15
KB
-rw-r--r--
binlog_database.result
9.67
KB
-rw-r--r--
binlog_delete_and_flush_index....
1.73
KB
-rw-r--r--
binlog_dmls_on_tmp_tables_read...
1.88
KB
-rw-r--r--
binlog_drop_if_exists.result
5.35
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
1.09
KB
-rw-r--r--
binlog_drop_temp_table_on_disc...
1.76
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
210.68
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
230.58
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
2.26
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
2.69
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
248.24
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
227.62
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
231.98
KB
-rw-r--r--
binlog_enforce_gtid_consistenc...
155.86
KB
-rw-r--r--
binlog_error_action.result
7.88
KB
-rw-r--r--
binlog_flush_logs_error.result
477
B
-rw-r--r--
binlog_foreign_key_parent_tabl...
566
B
-rw-r--r--
binlog_format_switch_in_tmp_ta...
2.65
KB
-rw-r--r--
binlog_grant.result
1.51
KB
-rw-r--r--
binlog_grant_alter_user.result
76.65
KB
-rw-r--r--
binlog_group_commit_flush_cras...
912
B
-rw-r--r--
binlog_group_commit_gtid_order...
1.3
KB
-rw-r--r--
binlog_group_commit_indefinite...
499
B
-rw-r--r--
binlog_group_commit_sync_delay...
599
B
-rw-r--r--
binlog_group_commit_sync_delay...
285
B
-rw-r--r--
binlog_group_commit_sync_no_de...
2.16
KB
-rw-r--r--
binlog_gtid_automatic_using_ro...
496
B
-rw-r--r--
binlog_gtid_cache.result
5
B
-rw-r--r--
binlog_gtid_errors.result
9.86
KB
-rw-r--r--
binlog_gtid_exhausted.result
1.26
KB
-rw-r--r--
binlog_gtid_implicit_commit.re...
12.4
KB
-rw-r--r--
binlog_gtid_innodb.result
6.31
KB
-rw-r--r--
binlog_gtid_mix_ok_packet_all_...
1.7
KB
-rw-r--r--
binlog_gtid_mix_response_packe...
3.69
KB
-rw-r--r--
binlog_gtid_mode_set_gtid_next...
10.7
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_row.re...
208.56
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_row_in...
244.07
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_row_my...
245.21
KB
-rw-r--r--
binlog_gtid_mysqlbinlog_start_...
45.14
KB
-rw-r--r--
binlog_gtid_mysqldump.result
657
B
-rw-r--r--
binlog_gtid_next_begin_caused_...
1.4
KB
-rw-r--r--
binlog_gtid_next_partially_fai...
1.31
KB
-rw-r--r--
binlog_gtid_next_partially_fai...
6.7
KB
-rw-r--r--
binlog_gtid_next_single_stmt_t...
9.6
KB
-rw-r--r--
binlog_gtid_next_temporary_tab...
1.1
KB
-rw-r--r--
binlog_gtid_next_xa.result
36.07
KB
-rw-r--r--
binlog_gtid_ps_reprepare.resul...
3.06
KB
-rw-r--r--
binlog_gtid_purge_binlog_at_st...
597
B
-rw-r--r--
binlog_gtid_rbr_only_flag.resu...
1.63
KB
-rw-r--r--
binlog_gtid_reset_consistency_...
586
B
-rw-r--r--
binlog_gtid_row_ctype_ucs.resu...
1.43
KB
-rw-r--r--
binlog_gtid_simple_recovery.re...
1.82
KB
-rw-r--r--
binlog_gtid_state_update_deadl...
625
B
-rw-r--r--
binlog_gtid_stm_ctype_ucs.resu...
1.53
KB
-rw-r--r--
binlog_gtid_unknown_xid.result
1.21
KB
-rw-r--r--
binlog_gtid_utils.result
13.28
KB
-rw-r--r--
binlog_gtids_table_gcov.result
1.72
KB
-rw-r--r--
binlog_implicit_commit.result
12.4
KB
-rw-r--r--
binlog_incident.result
497
B
-rw-r--r--
binlog_incident_ignore.result
497
B
-rw-r--r--
binlog_index.result
11.61
KB
-rw-r--r--
binlog_innodb.result
6.31
KB
-rw-r--r--
binlog_innodb_row.result
3.12
KB
-rw-r--r--
binlog_killed.result
3.74
KB
-rw-r--r--
binlog_killed_simulate.result
1.19
KB
-rw-r--r--
binlog_max_extension.result
424
B
-rw-r--r--
binlog_max_flush_queue_time_wa...
189
B
-rw-r--r--
binlog_mixed_cache_stat.result
3.2
KB
-rw-r--r--
binlog_mixed_load_data.result
420
B
-rw-r--r--
binlog_mts_logical_clock.resul...
2.92
KB
-rw-r--r--
binlog_mts_logical_clock_gtid....
1.72
KB
-rw-r--r--
binlog_mysqlbinlog-cp932.resul...
358
B
-rw-r--r--
binlog_mysqlbinlog_base64.resu...
1.71
KB
-rw-r--r--
binlog_mysqlbinlog_concat.resu...
488
B
-rw-r--r--
binlog_mysqlbinlog_filter.resu...
1.48
KB
-rw-r--r--
binlog_mysqlbinlog_intvar.resu...
752
B
-rw-r--r--
binlog_mysqlbinlog_raw.result
832
B
-rw-r--r--
binlog_mysqlbinlog_rewrite_db....
1.8
KB
-rw-r--r--
binlog_mysqlbinlog_row.result
211.92
KB
-rw-r--r--
binlog_mysqlbinlog_row_innodb....
244.36
KB
-rw-r--r--
binlog_mysqlbinlog_row_myisam....
245.49
KB
-rw-r--r--
binlog_mysqlbinlog_row_trans.r...
17.45
KB
-rw-r--r--
binlog_mysqlbinlog_start_stop....
45.18
KB
-rw-r--r--
binlog_mysqlbinlog_start_stop_...
4.07
KB
-rw-r--r--
binlog_nogtid_mix_response_pac...
1.14
KB
-rw-r--r--
binlog_noop_dml_with_readonly....
1.35
KB
-rw-r--r--
binlog_old_versions.result
1.03
KB
-rw-r--r--
binlog_purge_binary_logs_stall...
236
B
-rw-r--r--
binlog_purge_binary_logs_to.re...
309
B
-rw-r--r--
binlog_query_filter_rules.resu...
187
B
-rw-r--r--
binlog_rbr_only_savepoint.resu...
202
B
-rw-r--r--
binlog_reset_connection_not_re...
611
B
-rw-r--r--
binlog_reset_master.result
14
B
-rw-r--r--
binlog_rewrite.result
10.15
KB
-rw-r--r--
binlog_rewrite_db_noleak.resul...
932
B
-rw-r--r--
binlog_rewrite_order.result
4.35
KB
-rw-r--r--
binlog_rewrite_suppress_use.re...
828
B
-rw-r--r--
binlog_rotate_bgc_sync.result
1.54
KB
-rw-r--r--
binlog_rotate_deadlock.result
852
B
-rw-r--r--
binlog_row_binlog.result
39.5
KB
-rw-r--r--
binlog_row_cache_stat.result
3.2
KB
-rw-r--r--
binlog_row_create_select_crash...
446
B
-rw-r--r--
binlog_row_ctype_cp932.result
87.58
KB
-rw-r--r--
binlog_row_ctype_ucs.result
1.43
KB
-rw-r--r--
binlog_row_delete_all_rows.res...
869
B
-rw-r--r--
binlog_row_drop_tbl.result
567
B
-rw-r--r--
binlog_row_drop_tmp_tbl.result
4.86
KB
-rw-r--r--
binlog_row_insert_select.resul...
809
B
-rw-r--r--
binlog_row_kill_create_select....
1.21
KB
-rw-r--r--
binlog_row_mix_innodb_myisam.r...
30.51
KB
-rw-r--r--
binlog_row_mysqlbinlog_db_filt...
1.5
KB
-rw-r--r--
binlog_row_mysqlbinlog_verbose...
2.84
KB
-rw-r--r--
binlog_row_query_log_events.re...
442
B
-rw-r--r--
binlog_server_id.result
459
B
-rw-r--r--
binlog_server_start_options.re...
49
B
-rw-r--r--
binlog_set_gtid_mode_ongoing_t...
8.01
KB
-rw-r--r--
binlog_set_trans_dependency_de...
1.29
KB
-rw-r--r--
binlog_sf.result
1.67
KB
-rw-r--r--
binlog_shutdown_hang.result
406
B
-rw-r--r--
binlog_simulate_crash_and_erro...
2.44
KB
-rw-r--r--
binlog_spurious_ddl_errors.res...
2.97
KB
-rw-r--r--
binlog_sql_mode.result
3.69
KB
-rw-r--r--
binlog_start_comment.result
371
B
-rw-r--r--
binlog_start_slave_heartbeat.r...
259
B
-rw-r--r--
binlog_stm_binlog.result
37.96
KB
-rw-r--r--
binlog_stm_blackhole.result
7.78
KB
-rw-r--r--
binlog_stm_cache_stat.result
3.2
KB
-rw-r--r--
binlog_stm_ctype_cp932.result
87.58
KB
-rw-r--r--
binlog_stm_ctype_ucs.result
1.53
KB
-rw-r--r--
binlog_stm_delete_all_rows.res...
873
B
-rw-r--r--
binlog_stm_do_db.result
2.82
KB
-rw-r--r--
binlog_stm_drop_tbl.result
513
B
-rw-r--r--
binlog_stm_drop_tmp_tbl.result
7.11
KB
-rw-r--r--
binlog_stm_insert_select.resul...
762
B
-rw-r--r--
binlog_stm_mix_innodb_myisam.r...
36.05
KB
-rw-r--r--
binlog_stm_ps.result
1.16
KB
-rw-r--r--
binlog_stm_row.result
3.07
KB
-rw-r--r--
binlog_stm_unsafe_warning.resu...
4.8
KB
-rw-r--r--
binlog_stm_user_variables.resu...
5.38
KB
-rw-r--r--
binlog_switch_inside_trans.res...
7.97
KB
-rw-r--r--
binlog_temporary_tables_user_v...
124
B
-rw-r--r--
binlog_tmp_table.result
905
B
-rw-r--r--
binlog_transaction_dependency_...
3.2
KB
-rw-r--r--
binlog_transaction_dependency_...
1.56
KB
-rw-r--r--
binlog_transaction_write_set_s...
1.08
KB
-rw-r--r--
binlog_transaction_write_set_s...
448
B
-rw-r--r--
binlog_transaction_write_set_s...
351
B
-rw-r--r--
binlog_transaction_write_set_s...
1.51
KB
-rw-r--r--
binlog_truncate_kill.result
1.23
KB
-rw-r--r--
binlog_truncate_myisam.result
2.97
KB
-rw-r--r--
binlog_trx_empty_assertions.re...
884
B
-rw-r--r--
binlog_unsafe.result
190.13
KB
-rw-r--r--
binlog_unsafe_stmt_capable_eng...
215.37
KB
-rw-r--r--
binlog_use_gtid_skip.result
311
B
-rw-r--r--
binlog_user_if_exists.result
14.76
KB
-rw-r--r--
binlog_variables_log_bin.resul...
319
B
-rw-r--r--
binlog_variables_log_bin_index...
313
B
-rw-r--r--
binlog_variables_log_statement...
1.03
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
245
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
2.2
KB
-rw-r--r--
binlog_wait_for_executed_gtid_...
237
B
-rw-r--r--
binlog_wait_for_executed_gtid_...
590
B
-rw-r--r--
binlog_write_error.result
2.8
KB
-rw-r--r--
binlog_writeset_history_protec...
671
B
-rw-r--r--
binlog_wrong_last_committed.re...
574
B
-rw-r--r--
binlog_xa_handling.result
1.49
KB
-rw-r--r--
binlog_xa_modify_gtid_executed...
2.35
KB
-rw-r--r--
binlog_xa_prepare_failure.resu...
1.05
KB
-rw-r--r--
binlog_xa_prepared_disconnect....
26.74
KB
-rw-r--r--
binlog_xa_rollback_failure.res...
588
B
-rw-r--r--
binlog_xa_select_gtid_executed...
863
B
-rw-r--r--
binlog_xa_trx_gtid_response_pa...
666
B
-rw-r--r--
binlog_xa_trx_split_across_bin...
1016
B
-rw-r--r--
log_builtin_as_identified_by_p...
7.11
KB
-rw-r--r--
show_binlog_events_no_lock.res...
324
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : binlog_gtid_mysqlbinlog_start_stop.result
CREATE TABLE t1 (a INT); RESET MASTER; SET TIMESTAMP= UNIX_TIMESTAMP("2031-01-01 12:00:00"); INSERT INTO t1 VALUES(1); SET TIMESTAMP= UNIX_TIMESTAMP("2032-01-01 12:00:00"); INSERT INTO t1 VALUES(2); SET TIMESTAMP= UNIX_TIMESTAMP("2033-01-01 12:00:00"); INSERT INTO t1 VALUES(3); FLUSH LOGS; SET TIMESTAMP= UNIX_TIMESTAMP("2034-01-01 12:00:00"); INSERT INTO t1 VALUES(4); SET TIMESTAMP= UNIX_TIMESTAMP("2035-01-01 12:00:00"); INSERT INTO t1 VALUES(5); FLUSH LOGS; ==== Local ==== ---- base64-output ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- offset ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ==== Local with 2 binlogs on command line ==== ---- base64-output ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- offset ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ==== Remote ==== ---- base64-output ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- offset ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ==== Remote with 2 binlogs on command line ==== ---- base64-output ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- offset ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-position stop-position ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- start-datetime stop-datetime ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ---- to-last-log ---- include/mysqlbinlog.inc /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; ROLLBACK/*!*/; # [empty] SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; SET @@session.pseudo_thread_id=#/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C latin1 *//*!*/; SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; use `test`/*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(1) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(2) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(3) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-3 SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(4) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#'/*!*/; SET TIMESTAMP=#/*!*/; BEGIN /*!*/; SET TIMESTAMP=#/*!*/; INSERT INTO t1 VALUES(5) /*!*/; COMMIT/*!*/; SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; # #:1-5 SET @@SESSION.GTID_NEXT= '#' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; ==== clean up ==== DROP TABLE t1;
Close
