stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; drop database if exists mysqltest; drop database if exists mysqltest2; drop database if exists mysqltest3; drop database if exists mysqltest; drop database if exists mysqltest2; drop database if exists mysqltest3; create database mysqltest2; create database mysqltest; create database mysqltest2; create table mysqltest2.foo (n int); insert into mysqltest2.foo values(4); create table mysqltest2.foo (n int); insert into mysqltest2.foo values(5); create table mysqltest.bar (m int); insert into mysqltest.bar values(15); select mysqltest2.foo.n,mysqltest.bar.m from mysqltest2.foo,mysqltest.bar; n m 4 15 drop database mysqltest; drop database if exists mysqltest2; drop database mysqltest; ERROR HY000: Can't drop database 'mysqltest'; database doesn't exist drop database mysqltest2; set sql_log_bin = 0; create database mysqltest2; create database mysqltest; show databases; Database mysql mysqltest mysqltest2 test create table mysqltest2.t1(n int, s char(20)); create table mysqltest2.t2(n int, s text); insert into mysqltest2.t1 values (1, 'one'), (2, 'two'), (3, 'three'); insert into mysqltest2.t2 values (11, 'eleven'), (12, 'twelve'), (13, 'thirteen'); create table mysqltest.t1(n int, s char(20)); create table mysqltest.t2(n int, s text); insert into mysqltest.t1 values (1, 'one test'), (2, 'two test'), (3, 'three test'); insert into mysqltest.t2 values (11, 'eleven test'), (12, 'twelve test'), (13, 'thirteen test'); set sql_log_bin = 1; show databases; Database mysql test create database mysqltest2; create table mysqltest2.t1(n int, s char(20)); insert into mysqltest2.t1 values (1, 'original foo.t1'); create table mysqltest2.t3(n int, s char(20)); insert into mysqltest2.t3 values (1, 'original foo.t3'); create database mysqltest3; create table mysqltest3.t1(n int, s char(20)); insert into mysqltest3.t1 values (1, 'original foo2.t1'); create database mysqltest; create table mysqltest.t1(n int, s char(20)); insert into mysqltest.t1 values (1, 'original bar.t1'); create table mysqltest.t3(n int, s char(20)); insert into mysqltest.t3 values (1, 'original bar.t3'); load data from master; show databases; Database mysql mysqltest mysqltest2 mysqltest3 test use mysqltest2; show tables; Tables_in_mysqltest2 t1 t3 select * from t1; n s 1 original foo.t1 use mysqltest3; show tables; Tables_in_mysqltest3 t1 select * from t1; n s 1 original foo2.t1 use mysqltest; show tables; Tables_in_mysqltest t1 t2 t3 select * from mysqltest.t1; n s 1 one test 2 two test 3 three test select * from mysqltest.t2; n s 11 eleven test 12 twelve test 13 thirteen test select * from mysqltest.t3; n s 1 original bar.t3 insert into mysqltest.t1 values (4, 'four test'); select * from mysqltest.t1; n s 1 one test 2 two test 3 three test 4 four test load table mysqltest.t1 from master; ERROR 42S01: Table 't1' already exists drop table mysqltest.t1; load table mysqltest.t1 from master; load table bar.t1 from master; ERROR HY000: Error from master: 'Table 'bar.t1' doesn't exist' drop database mysqltest; drop database mysqltest2; drop database mysqltest2; drop database mysqltest3;