The starting of the Server with the timezone settings works fine after
setting the TZ variable. I always looked at the output from select
@@global.time_zone. This was SYSTEM and so I beliefed the timezone
wasn't set right on the server.
Thanks and Regards
Michael
Thanks for the help,
but this isn't my problem. When you start the server as shown below, the
SYSTEM Timezone is used for the MySQL server. This could be seen when
executing the query select @@global.time_zone on the server. Than you
must get a SYSTEM in your data. The problem is that I wan't to start
the server with a different timezone than the system one, which can be
done by starting the server with --timzeone=..
Regards Michael
Dominik Klein wrote:
This was done as root and shows that TZ works.
dk:/usr/local/mysql # bin/mysql -V
bin/mysql Ver 14.12 Distrib 5.0.18, for pc-linux-gnu (i686) using
readline 5.0
dk:/usr/local/mysql # echo $TZ
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 802
dk:/usr/local/mysql # Starting mysqld daemon with databases from
/usr/local/mysql/data
dk:/usr/local/mysql # bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2006-03-27 09:26:35 |
+---------------------+
1 row in set (0.05 sec)
mysql> Bye
dk:/usr/local/mysql # support-files/mysql.server stop
Shutting down MySQL...STOPPING server from pid file
/usr/local/mysql/data/dk.pid
060327 09:26:45 mysqld ended
done
[1]+ Done bin/mysqld_safe --user=mysql
dk:/usr/local/mysql # export TZ="America/Argentina/Mendoza"
dk:/usr/local/mysql # bin/mysqld_safe --user=mysql &
[1] 889
dk:/usr/local/mysql # Starting mysqld daemon with databases from
/usr/local/mysql/data
dk:/usr/local/mysql # bin/mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2006-03-27 04:27:09 |
+---------------------+
1 row in set (0.00 sec)
mysql> Bye
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]