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

MySQL

Development Platform:

Visual C++

  1. source include/master-slave.inc;
  2. connection master;
  3. set SQL_LOG_BIN=0;
  4. set timestamp=200006;
  5. drop table if exists foo;
  6. create table foo(t timestamp not null,a char(1));
  7. insert into foo ( a) values ('F');
  8. @r/rpl000006.result select unix_timestamp(t) from foo;
  9. connection slave;
  10. drop table if exists foo;
  11. load table foo from master;
  12. @r/rpl000006.result select unix_timestamp(t) from foo;
  13. connection master;
  14. drop table foo;
  15. save_master_pos;
  16. connection slave;
  17. sync_with_master;