rpl000017.test
上传用户:tsgydb
上传日期:2007-04-14
资源大小:10674k
文件大小:1k
- connect (master,localhost,root,,test,0,mysql-master.sock);
- connect (slave,localhost,root,,test,0,mysql-slave.sock);
- connection master;
- reset master;
- grant file on *.* to replicate@localhost identified by
- 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa';
- connection slave;
- slave start;
- connection master;
- drop table if exists t1;
- create table t1(n int);
- insert into t1 values(24);
- save_master_pos;
- connection slave;
- sync_with_master;
- select * from t1;
- connection master;
- drop table t1;
- save_master_pos;
- connection slave;
- sync_with_master;