rpl000014.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- source include/master-slave.inc;
- source include/have_default_master.inc;
- connection master;
- show master status;
- save_master_pos;
- connection slave;
- sync_with_master;
- show slave status;
- change master to master_log_pos=73;
- slave stop;
- change master to master_log_pos=73;
- show slave status;
- slave start;
- show slave status;
- change master to master_log_pos=173;
- show slave status;
- connection master;
- show master status;
- create table if not exists foo(n int);
- drop table if exists foo;
- create table foo (n int);
- insert into foo values (1),(2),(3);
- save_master_pos;
- connection slave;
- change master to master_log_pos=73;
- sync_with_master;
- select * from foo;
- connection master;
- drop table foo;
- save_master_pos;
- connection slave;
- sync_with_master;