RE: Mysql server time setting.

2003-11-20 Thread Don Read
On 19-Nov-2003 Jeff McKeon wrote: > I'm running mysql on a redhat system starting it from a script in > /etc/init.d/ as is the default with the rpm install. I can't seem to > set the timezone environmental variable to change nomatter what I put in > the /etc/my.cnf file. > > Can anyone help me w

RE: Mysql server time setting.

2003-11-19 Thread Jeff McKeon
ginal Message- > From: Jeff McKeon > Sent: Wednesday, November 19, 2003 4:54 PM > To: [EMAIL PROTECTED] > Subject: Mysql server time setting. > > > I have two servers replicating. Server one to server two. > > If I do a show variables on server one it show the timezone

Mysql server time setting.

2003-11-19 Thread Jeff McKeon
I have two servers replicating. Server one to server two. If I do a show variables on server one it show the timezone as EST, on server two it shows it as GMT. Where is this set and how can I change server one to GMT? The linux box itself, that mysql server one runs on is set for GMT Thank