home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Database / mysql-max-3.23.55.sit / mysql-max-3.23.55-apple-darwi.1 / mysql-test / t / rpl000003.test < prev    next >
Encoding:
Text File  |  2003-01-21  |  371 b   |  16 lines  |  [TEXT/ttxt]
  1. source include/master-slave.inc;
  2. connection master;
  3. drop table if exists t1;
  4. create table t1(n int primary key);
  5. !insert into t1 values (1),(2),(2);
  6. insert into t1 values (3);
  7. save_master_pos;
  8. connection slave;
  9. sync_with_master;
  10. select * from t1;                                     
  11. connection master;
  12. drop table t1;
  13. save_master_pos;
  14. connection slave;
  15. sync_with_master;
  16.