I've got a RHEL3 server I just installed with mysql 4.0.16.
The hardware clock and system clock are both set to UTC and show the
correct time.
If I do a select Now(); from mysql it show's the correct time
However,
Unixtimestamp fields written to a table all are an hour off. They're
one hour ahead.
All the data on this system is replicated from a master. The master is
set correctly, hwclock and sysclock at UTC.
The same query:
Select max(from_unixtime(timestamp_field)) from table;
Run on both servers returns a result 1 hour ahead on the new slave.
A show variables on the new slave returns
*************************** 120. row ***************************
Variable_name: timezone
Value: IST
I'm sure I've missed something simple here but what?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
