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 th
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
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 da
Thanks for your help, but this is the problem I have. I can't specify
the timezone right when I start mysql with
mysqld_safe --user=mysql --timezone="America/Argentina/Mendoza"
or by setting the TZ enviroment variable and than start the server.
The timezone setting is ignored every time I start
or what I although could do to
start my Server in another than the SYSTEM timezone?
I use the MySQL 5.0.18 Server on a Suse Linux 10.0
From:
http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html
You can set the time zone for the server with the
--timezone=timezone_name option to mysq
Hello everybody,
I have a problem with replication of data from master to slave server.
The problem is, that the master is in a other timezone than the slave
and so inserts with using the now() function creates different values on
master and slave. If I want to update on the master and use the