1
drop table if exists t1, t2, t3, t4;
2
drop table if exists t1, t2, t3, t4;
4
Got one of the listed errors
6
ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
7
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
8
ERROR HY000: Could not initialize master info structure; more error messages can be found in the MySQL error log
10
change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root';
13
create temporary table temp_table (a char(80) not null);
14
insert into temp_table values ("testing temporary tables");
15
create table t1 (s text);
16
insert into t1 values('Could not break slave'),('Tried hard');
21
Master_Port MASTER_PORT
23
Master_Log_File master-bin.000001
27
Relay_Master_Log_File master-bin.000001
33
Replicate_Ignore_Table #
34
Replicate_Wild_Do_Table
35
Replicate_Wild_Ignore_Table
50
Seconds_Behind_Master #
51
Master_SSL_Verify_Server_Cert No
61
create table t2(m int not null auto_increment primary key);
62
insert into t2 values (34),(67),(123);
69
create table t3 select * from temp_table;
72
testing temporary tables
73
drop table temp_table, t3;
74
insert into t2 values(1234);
76
insert into t2 values(NULL);
77
set global sql_slave_skip_counter=1;
79
purge master logs to 'master-bin.000002';
81
Log_name master-bin.000002
83
Log_name master-bin.000003
85
purge binary logs to 'master-bin.000002';
90
SELECT @time_for_purge:=DATE_ADD('tmpval', INTERVAL 1 SECOND);
91
purge master logs before (@time_for_purge);
95
insert into t2 values (65);
100
Master_Port MASTER_PORT
102
Master_Log_File master-bin.000003
103
Read_Master_Log_Pos #
106
Relay_Master_Log_File master-bin.000003
108
Slave_SQL_Running Yes
112
Replicate_Ignore_Table #
113
Replicate_Wild_Do_Table
114
Replicate_Wild_Ignore_Table
118
Exec_Master_Log_Pos #
123
Master_SSL_Allowed No
129
Seconds_Behind_Master #
130
Master_SSL_Verify_Server_Cert No
142
create temporary table temp_table (a char(80) not null);
143
insert into temp_table values ("testing temporary tables part 2");
144
create table t3 (n int);
145
select count(*) from t3 where n >= 4;
148
create table t4 select * from temp_table;
155
File Position Binlog_Do_DB Binlog_Ignore_DB
156
master-bin.000005 # <Binlog_Do_DB> <Binlog_Ignore_DB>
159
testing temporary tables part 2
162
Master_Host 127.0.0.1
164
Master_Port MASTER_PORT
166
Master_Log_File master-bin.000005
167
Read_Master_Log_Pos #
170
Relay_Master_Log_File master-bin.000005
172
Slave_SQL_Running Yes
176
Replicate_Ignore_Table #
177
Replicate_Wild_Do_Table
178
Replicate_Wild_Ignore_Table
182
Exec_Master_Log_Pos #
187
Master_SSL_Allowed No
193
Seconds_Behind_Master #
194
Master_SSL_Verify_Server_Cert No
200
select count(*) from t3 where n >= 4;
204
drop table if exists t1,t2,t3,t4;
206
show binlog events in 'non existing_binlog_file';
207
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
208
purge master logs before now();
209
show binlog events in '';
210
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
211
purge master logs before now();