source include/master-slave.inc; drop database if exists test_$1; create database test_$1; create table test_$1.t1 ( n int); alter table test_$1.t1 add m int; insert into test_$1.t1 values (1,2); create table test_$1.t2 (n int); insert into test_$1.t2 values (45); rename table test_$1.t2 to test_$1.t3, test_$1.t1 to test_$1.t2; save_master_pos; connection slave; sync_with_master; select * from test_$1.t2; select * from test_$1.t3; connection master; drop database test_$1; save_master_pos; connection slave; sync_with_master;