# # Test forced timestamp # source include/master-slave.inc; # Don't log table creating to the slave as we want to test LOAD TABLE 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; connection slave; load table t1 from master; select unix_timestamp(t) from t1; # Delete the created table on master and slave connection master; set SQL_LOG_BIN=1,timestamp=default; drop table t1; save_master_pos; connection slave; sync_with_master; connection master; # # Test copying table with checksum # # Don't log table creating to the slave as we want to test LOAD TABLE set SQL_LOG_BIN=0; CREATE TABLE t1 ( a int not null ) ENGINE=MyISAM MAX_ROWS=4000 CHECKSUM=1; INSERT INTO t1 VALUES (1); save_master_pos; connection slave; sync_with_master; load table t1 from master; check table t1; drop table t1; connection master; drop table t1; save_master_pos; connection slave; sync_with_master;