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 ?
--
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
