1include/master-slave.inc 2[connection master] 3connection slave; 4set global time_zone='Europe/Moscow'; 5set time_zone='UTC'; 6stop slave; 7start slave; 8connection master; 9set global mysql56_temporal_format=false; 10set global time_zone='Europe/Moscow'; 11set time_zone='UTC'; 12create table t1 (pk int primary key, t timestamp not null); 13set timestamp = 1288477526; 14insert into t1 values (1,null); 15set timestamp = 1288481126; 16insert into t1 values (2,null); 17connection slave; 18select pk, t, unix_timestamp(t) from t1; 19pk t unix_timestamp(t) 201 2010-10-30 22:25:26 1288477526 212 2010-10-30 23:25:26 1288481126 22set time_zone=default; 23select pk, t, unix_timestamp(t) from t1; 24pk t unix_timestamp(t) 251 2010-10-31 02:25:26 1288477526 262 2010-10-31 02:25:26 1288481126 27set global time_zone=default; 28connection master; 29drop table t1; 30set global time_zone=default; 31set global mysql56_temporal_format=default; 32include/rpl_end.inc 33