Difference between revisions of "MySQL Time Zone Tables"

From MythTV Official Wiki
Jump to: navigation, search
m (Added Troubleshooting Category)
(Changed distro status section to separate do/dont and added Gentoo)
Line 3: Line 3:
 
in MySQL.
 
in MySQL.
  
Distributions that '''don't''' have the time zone tables loaded (please update or change
+
Distributions that '''don't''' have the time zone tables loaded:
this list to distributions that '''do''' have the tables loaded):
+
 
<pre>
 
<pre>
 
Ubuntu 12.04
 
Ubuntu 12.04
 
Mythbuntu 10.04
 
Mythbuntu 10.04
 
Fedora 16
 
Fedora 16
 +
</pre>
 +
 +
Distributions that '''do''' have the timezone tables loaded:
 +
<pre>
 +
Gentoo (confirmed for dev-db/mysql-5.1.61)
 
</pre>
 
</pre>
  

Revision as of 14:20, 6 August 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:

Ubuntu 12.04
Mythbuntu 10.04
Fedora 16

Distributions that do have the timezone tables loaded:

Gentoo (confirmed for dev-db/mysql-5.1.61)

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.


Important.png Note: If the time zone tables are updated, then the procedure below should be repeated.

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: