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;
8
create table t1(n int not null auto_increment primary key);
9
insert into t1 values (1),(2),(3),(4);
11
create table t2(n int not null auto_increment primary key);
12
insert into t2 values (1),(2);
13
insert into t2 values (3),(4);
15
start slave until master_log_file='master-bin.000001', master_log_pos=323;
26
Master_Port MASTER_PORT
28
Master_Log_File master-bin.000001
32
Relay_Master_Log_File master-bin.000001
38
Replicate_Ignore_Table #
39
Replicate_Wild_Do_Table
40
Replicate_Wild_Ignore_Table
46
Until_Condition Master
47
Until_Log_File master-bin.000001
55
Seconds_Behind_Master #
56
Master_SSL_Verify_Server_Cert No
61
start slave until master_log_file='master-no-such-bin.000001', master_log_pos=291;
72
Master_Port MASTER_PORT
74
Master_Log_File master-bin.000001
78
Relay_Master_Log_File master-bin.000001
84
Replicate_Ignore_Table #
85
Replicate_Wild_Do_Table
86
Replicate_Wild_Ignore_Table
92
Until_Condition Master
93
Until_Log_File master-no-such-bin.000001
101
Seconds_Behind_Master #
102
Master_SSL_Verify_Server_Cert No
107
start slave until relay_log_file='slave-relay-bin.000003', relay_log_pos=746;
114
Master_Host 127.0.0.1
116
Master_Port MASTER_PORT
118
Master_Log_File master-bin.000001
119
Read_Master_Log_Pos #
122
Relay_Master_Log_File master-bin.000001
128
Replicate_Ignore_Table #
129
Replicate_Wild_Do_Table
130
Replicate_Wild_Ignore_Table
134
Exec_Master_Log_Pos #
136
Until_Condition Relay
137
Until_Log_File slave-relay-bin.000003
139
Master_SSL_Allowed No
145
Seconds_Behind_Master #
146
Master_SSL_Verify_Server_Cert No
153
start slave until master_log_file='master-bin.000001', master_log_pos=776;
156
Master_Host 127.0.0.1
158
Master_Port MASTER_PORT
160
Master_Log_File master-bin.000001
161
Read_Master_Log_Pos #
164
Relay_Master_Log_File master-bin.000001
170
Replicate_Ignore_Table #
171
Replicate_Wild_Do_Table
172
Replicate_Wild_Ignore_Table
176
Exec_Master_Log_Pos #
178
Until_Condition Master
179
Until_Log_File master-bin.000001
181
Master_SSL_Allowed No
187
Seconds_Behind_Master #
188
Master_SSL_Verify_Server_Cert No
193
start slave until master_log_file='master-bin', master_log_pos=561;
194
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
195
start slave until master_log_file='master-bin.000001', master_log_pos=561, relay_log_pos=12;
196
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
197
start slave until master_log_file='master-bin.000001';
198
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
199
start slave until relay_log_file='slave-relay-bin.000002';
200
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
201
start slave until relay_log_file='slave-relay-bin.000002', master_log_pos=561;
202
ERROR HY000: Incorrect parameter or combination of parameters for START SLAVE UNTIL
203
start slave sql_thread;
204
start slave until master_log_file='master-bin.000001', master_log_pos=776;
206
Note 1254 Slave is already running