Difference between revisions of "MySQL Time Zone Tables"
From MythTV Official Wiki
(Add Fedora 16 to the list of distributions that don't install the TZ information) |
m (Added Troubleshooting Category) |
||
Line 1: | Line 1: | ||
− | [[Category:MySQL]] | + | [[Category:MySQL]] [[Category:Troubleshooting]] |
Starting with MythTV version 0.26, the time zone tables must be loaded | Starting with MythTV version 0.26, the time zone tables must be loaded | ||
in MySQL. | in MySQL. |
Revision as of 22:15, 8 July 2012
Starting with MythTV version 0.26, the time zone tables must be loaded in MySQL.
Distributions that don't have the time zone tables loaded (please update or change this list to distributions that do have the tables loaded):
Ubuntu 12.04 Mythbuntu 10.04 Fedora 16
To see if the tables are already loaded, enter mysql and type:
SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');
If the response looks like:
+--------------------------------------------------------------+ | CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') | +--------------------------------------------------------------+ | 2012-06-07 08:00:00 | +--------------------------------------------------------------+
the tables are loaded and no further action is required.
If the response looks like:
+--------------------------------------------------------------+ | CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') | +--------------------------------------------------------------+ | NULL | +--------------------------------------------------------------+
then the tables must be loaded.
Assuming the distribution's time zone information is in /usr/share/zoneinfo, type:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p<yourpassword> mysql
Restart MySQL, and repeat the initial test.
References: