rpl000001.test
Upload User: tsgydb
Upload Date: 2007-04-14
Package Size: 10674k
Code Size: 1k
Category:

MySQL

Development Platform:

Visual C++

  1. source include/master-slave.inc;
  2. connection master;
  3. use test;
  4. drop table if exists t1;
  5. create table t1 (word char(20) not null);
  6. load data infile '../../std_data/words.dat' into table t1;
  7. drop table if exists foo;
  8. set password = password('foo');
  9. set password = password('');
  10. create table foo(n int);
  11. insert into foo values(1),(2);
  12. save_master_pos;
  13. connection slave;
  14. sync_with_master;
  15. use test;
  16. select * from foo;
  17. select sum(length(word)) from t1;
  18. connection master;
  19. drop table t1;
  20. save_master_pos;
  21. connection slave;
  22. sync_with_master;