rpl000006.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- set SQL_LOG_BIN=0,timestamp=200006;
- create table t1(t timestamp not null,a char(1));
- insert into t1 ( a) values ('F');
- select unix_timestamp(t) from t1;
- unix_timestamp(t)
- 200006
- load table t1 from master;
- select unix_timestamp(t) from t1;
- unix_timestamp(t)
- 200006
- set SQL_LOG_BIN=1,timestamp=default;
- drop table t1;
- set SQL_LOG_BIN=0;
- CREATE TABLE t1 (
- a int not null
- ) ENGINE=MyISAM MAX_ROWS=4000 CHECKSUM=1;
- INSERT INTO t1 VALUES (1);
- load table t1 from master;
- check table t1;
- Table Op Msg_type Msg_text
- test.t1 check status OK
- drop table t1;
- drop table t1;