Difference between revisions of "MySQL Time Zone Tables"
From MythTV Official Wiki
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 | + | Distributions that '''don't''' have the time zone 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.
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:
