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 time as
criterion the slave doesn't get the update.
After searching the internet the problem is, that the MySQL Server
starts with the default system timezone. But this could be changed. So
configured my slave server so, that it has the same timezone as the
master server. For doing this I used the:
set global time_zone='America/Argentina/Mendoza';
command. After changing the timezone everything works fine and all data
is replictated correctly.
The problem is, that I must configure it manually every time the server
restarts and I want to do it automatically by starting. But this doesn't
work. I tried to use the
mysqld_safe --user=mysql --timezone=America/Argentina/Mendoza
command, but the server starts with SYSTEM timezone. I although put an
entry in my.cnf configuration file which looks:
#[mysqld_safe]
timezone = America/Argentina/Mendoza
But this doesn't work to.
Can anybody tell me what's my error, 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
Regards Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
