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

MySQL

Development Platform:

Visual C++

  1. connect (master,localhost,root,,test,0,mysql-master.sock);
  2. connect (slave,localhost,root,,test,0,mysql-slave.sock);
  3. connection slave;
  4. reset slave;
  5. slave start;
  6. connection master;
  7. show master logs;
  8. drop table if exists t1;
  9. create table t1(n int);
  10. insert into t1 values (3351);
  11. save_master_pos;
  12. connection slave;
  13. sync_with_master;
  14. select * from t1;
  15. connection master;
  16. drop table t1;
  17. save_master_pos;
  18. connection slave;
  19. sync_with_master;