Hello Sinisa,
Tuesday, August 07, 2001, 4:48:56 PM, you wrote:
1) SUSE. Destributions does not have TZ variable set by default. And
the idea is it worked quite well wothout it with .39
2) The strange thing is why settng TZ makes mysql to print correct
timezone in variables but still produces the wrong time ?
SM> Peter Zaitsev writes:
>> Hello mysql,
>>
>> It seems like you made an incomportable changes in 3.23.40 without
>> taking a time to write a release note :(
>>
>> The mysql 3.23.39 used the system timezone by default:
>>
>> maindb:/spylog/mysql/logs # date
>> Tue Aug 7 13:31:56 MSD 2001
>>
>> | transaction_isolation | READ-COMMITTED
>
> |
>> | timezone | MSD
>
> |
>> | tmp_table_size | 4194304
>>
>>
>> Therefore MYSQL 3.23.40 does not determinate the timezone correctly:
>>
>> |
>> | transaction_isolation | READ-COMMITTED
>
> |
>> | timezone | Local time zone must be set--see´Ÿ manual page
>
> |
>> | tmp_table_size | 4194304
>
> |
>>
>>
>> It uses GMT in this case which could dammage the data (as went in my
>> case)
>>
>> The other thing is the manual does not contains much info about
>> setting timezone - only option to safe_mysqld which exports TZ
>> variable, which does not work:
>>
>> root 19380 1 0 13:43 pts/8 00:00:00 sh /usr/local/mysql/bin/safe_mysqld
>--mysqld=mysqld --user=mysql --pid-file=/spylog/db/mysqld.pid --timezone=MSD
>--datadir=/spylog/db
>>
>> It set's the timezone according to required value but date still bad:
>>
>> | transaction_isolation | READ-COMMITTED
>
> |
>> | timezone | MSD
>
> |
>> | tmp_table_size | 4194304
>>
>>
>> mysql> select now();
>> +---------------------+
>> | now() |
>> +---------------------+
>> | 2001-08-07 09:44:44 |
>> +---------------------+
>> 1 row in set (0.00 sec)
>>
>> Therefore date returns correct value.
>>
>> rat:/spylog/layers # date
>> Tue Aug 7 13:47:05 MSD 2001
>> rat:/spylog/layers #
>>
>>
>> Do you have any ideas about this ? How I can fix the problem ?
>>
>>
>>
>> Peter mailto:[EMAIL PROTECTED]
SM> Hi Pjotr,
SM> I just tested the above, and it worked just fine for me with 4.0.
SM> But I have noticed something. If I mess up my shell, it will mess up
SM> all programs started from it, including MySQL. We can not do anything
SM> about it ...
SM> If a shell that starts up MySQL does not have TZ set properly then
SM> there is not much we can do about it ...
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
