MySQL timezone question

loosenut

This is more of a mySQL question, not really a PHP question, but maybe someone can help me.

I'm trying to set my timezone for my mysql daemon. I thought this could be done by adding this line to my.cnf:

[mysqld]
set-variable = TZ=PST

But mysqld won't start if I add that.

The reason I'm doing this is because when I use CURRENT_TIMESTAMP in mySQL, it is 8 hours ahead of local time (I'm at PST). Maybe there is a workaround... could I subtract 8 from that value somehow? How would I do that in PHP (or in mySQL)?

Thanks,
Jason

nnichols

Try this -

[mysqld]
TZ=PST
export TZ

If it doesn't work read this and see what you make of it - http://www.mysql.com/doc/en/safe_mysqld.html

Hope this helps 😉

loosenut

Thank you, but that didn't work.

Here are the entire contents of my.cnf:

[client]
socket=/var/lib/mysql/mysql.sock

[mysqld]
socket=/var/lib/mysql/mysql.sock
TZ=PST
export TZ

When I add the last two lines, and try to run the server, I get this:

/etc/rc.d/init.d/mysql start

Starting mysqld daemon with databases from /var/lib/mysql

030110 10:28:20 mysqld ended

It works fine if I don't have the last two lines (except for the timezone being off, of course).

I'm using version 3.23.49

nnichols

If you read the page linked from my previous post it does mention that not all directives can be set through an option file.

You will probably need to set it in a startup script.

Good luck!

colbec

Perhaps the first thing to do is check that the system itself is set up with the correct timezone. I believe MySQL picks up the timezone from the system env. variable if it can.