12 messages in com.mysql.lists.bugsRe: Timezone problem.
FromSent OnAttachments
Peter Zaitsev07 Aug 2001 02:54 
Sinisa Milivojevic07 Aug 2001 05:48 
Peter Zaitsev07 Aug 2001 06:19 
Peter Zaitsev07 Aug 2001 06:46 
Sinisa Milivojevic07 Aug 2001 07:05 
Peter Zaitsev07 Aug 2001 07:28 
Peter Zaitsev07 Aug 2001 07:41 
Heikki Tuuri07 Aug 2001 08:10 
Michael Widenius07 Aug 2001 11:19 
Sasha Pachev07 Aug 2001 13:45 
Sinisa Milivojevic08 Aug 2001 03:40 
Heikki Tuuri08 Aug 2001 06:05 
Subject:Re: Timezone problem.
From:Sinisa Milivojevic (sin@mysql.com)
Date:08/08/2001 03:40:27 AM
List:com.mysql.lists.bugs

Peter Zaitsev writes:

Hello Michael,

Tuesday, August 07, 2001, 10:20:18 PM, you wrote:

The question is which place do you do aply timezone ?

I found the following interesting thing: Then mysql is started it uses correct timestamp, therefore INNODB is started with wrong timestamp...

010807 12:59:44 mysqld started 010807 8:59:45 InnoDB: Started

The above means that timezone has changed between the two calls ..

Between the two was tzset call.

This is a typical case when a zone is changed from GMT to something else !!!

And you are 4 hours before GMT, aren't you ??

If on Linux, check where does /etc/localtime point to.

Simply, your startup scripts are not well setup. TZ should be set at the machine boot.

-- Best regards, Peter mailto:pz@spylog.ru

-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com