|
1
by brian
clean slate |
1 |
source include/master-slave.inc; |
2 |
--disable_warnings
|
|
3 |
drop database if exists mysqltest; |
|
4 |
--enable_warnings
|
|
5 |
create database mysqltest; |
|
6 |
||
7 |
create table mysqltest.t1 ( n int); |
|
8 |
alter table mysqltest.t1 add m int; |
|
9 |
insert into mysqltest.t1 values (1,2); |
|
10 |
create table mysqltest.t2 (n int); |
|
11 |
insert into mysqltest.t2 values (45); |
|
12 |
rename table mysqltest.t2 to mysqltest.t3, mysqltest.t1 to mysqltest.t2; |
|
13 |
save_master_pos; |
|
14 |
connection slave; |
|
15 |
sync_with_master; |
|
16 |
select * from mysqltest.t2; |
|
17 |
select * from mysqltest.t3; |
|
18 |
connection master; |
|
19 |
drop database mysqltest; |
|
20 |
save_master_pos; |
|
21 |
connection slave; |
|
22 |
sync_with_master; |
|
23 |
||
24 |
# End of 4.1 tests |