2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
call mtr.add_suppression ("Slave I/O: Got fatal error 1236 from master when reading data from binary");
9
File Position Binlog_Do_DB Binlog_Ignore_DB
10
master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB>
11
include/stop_slave.inc
12
change master to master_log_pos=75;
17
Master_Port MASTER_PORT
19
Master_Log_File master-bin.000001
23
Relay_Master_Log_File master-bin.000001
29
Replicate_Ignore_Table #
30
Replicate_Wild_Do_Table
31
Replicate_Wild_Ignore_Table
46
Seconds_Behind_Master #
47
Master_SSL_Verify_Server_Cert No
53
include/stop_slave.inc
58
Master_Port MASTER_PORT
60
Master_Log_File master-bin.000001
61
Read_Master_Log_Pos 75
64
Relay_Master_Log_File master-bin.000001
70
Replicate_Ignore_Table #
71
Replicate_Wild_Do_Table
72
Replicate_Wild_Ignore_Table
76
Exec_Master_Log_Pos 75
87
Seconds_Behind_Master #
88
Master_SSL_Verify_Server_Cert No
94
File Position Binlog_Do_DB Binlog_Ignore_DB
95
master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB>
96
create table if not exists t1 (n int);
97
drop table if exists t1;
98
create table t1 (n int);
99
insert into t1 values (1),(2),(3);
100
change master to master_log_pos=4;
102
select * from t1 ORDER BY n;