mysql set time_zone possible values

[Greywacke]

hi there,unfortunately i cannot find all the possible values for setting this to on a mysql 5.0.91 server... i find no reference to it! the reason why i ask is because timezones are given in various formats and so forth world wide - and i need to set the timezone on the page for the location the site installation is made for. does anybody know where i could get this? in the timezone conversion class, the possible timezones are set in the php documents - but i have no idea what the possible time_zone values for the page scope would be.

[gar onn]

First result on google might felp you out: http://goo.gl/Y9Xq6found this:

I thought this information will helps somebody who are looking for changing mysql timezone. The steps are:1. Download the timezone table structure and data from http://dev.mysql.com/downloads/timezones.html2. Copy and paste the data in your Mysql/data/mysql folder3. Restart your mysql server.4. mysql> SET GLOBAL time_zone = 'America/Toronto';5. mysql> SET SESSION time_zone = 'America/Toronto';6. Check SELECT @ @global.time_zone , @ @session.time_zone ;It should give you the time zone you set just before.