After timezone table update, Convert_tz still returns NULL with named timezones. what to do??
Posted by: Stephane Halle
Date: November 09, 2011 11:01AM

Hi all,

I recently installed MySQL Server 5.5 on my Windows 7 machine. All mysql.timezone* tables are present but empty,
so I :
- went here : http://dev.mysql.com/downloads/timezones.html
- downloaded the POSIX package
- stopped the MYSQL running service
- updated the files in the data/mysql subfolder in the MySQL installation folder
- restarted the MYSQL service

and using the convert_tz function still returns NULL when using named timezones.

So I looked into the tables, are they are still all empty. ??? Seems the update does not work?
I also tried finding just the .sql scripts so I can manually add the the data to the tables one table at a time, and I couldn't find any.

Any ideas? Anything would help, thanks in advance,

Steph

Options: ReplyQuote


Subject
Views
Written By
Posted
After timezone table update, Convert_tz still returns NULL with named timezones. what to do??
5418
November 09, 2011 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.