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