rpl000001.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- source include/master-slave.inc;
- connection master;
- use test;
- drop table if exists t1;
- create table t1 (word char(20) not null);
- load data infile '../../std_data/words.dat' into table t1;
- drop table if exists foo;
- set password = password('foo');
- set password = password('');
- create table foo(n int);
- insert into foo values(1),(2);
- save_master_pos;
- connection slave;
- sync_with_master;
- use test;
- select * from foo;
- select sum(length(word)) from t1;
- connection master;
- drop table t1;
- save_master_pos;
- connection slave;
- sync_with_master;