<div dir="ltr">I am in the process of installing MythTV 0.26.0 on a Slackware 14.0 system. After initializing MySQL as described in the MythTV documentation, on starting mythtv-setup I am getting the following:<div><br></div>
<div> MySQL time zone support is missing. Please install it and try again. See 'mysql_tzinfo_to_sql' for assistance.<br></div><div><br></div><div style>I found out that this a new thing in 0.26, and the way around consists of loading the timezone tables with</div>
<div style><br></div><div style> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql </div><div style><br></div><div style>This seems to work, although it spits out a number of diagnostics like the following:</div>
<div style><br></div><div style><div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh87' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh88' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/Asia/Riyadh89' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh87' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh88' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/Mideast/Riyadh89' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.</div><div>Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh87' as time zone. Skipping it.</div>
<div>Warning: Unable to load '/usr/share/zoneinfo/posix/Asia/Riyadh88' as time zone. Skipping it.</div><div><br></div><div style>However, the timezones seem to have been loaded all right:</div><div style><br></div>
<div style>$ mysql</div><div style><br></div><div style><div>mysql> SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');</div><div>+--------------------------------------------------------------+</div>
<div>| CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York') |</div><div>+--------------------------------------------------------------+</div><div>| 2012-06-07 08:00:00 |</div>
<div>+--------------------------------------------------------------+</div><div>1 row in set (0.00 sec)</div><div><br></div><div style>However, launching mythtv-setup again elicits exactly the same "MySQL time zone support is missing." diagnostic as before. I have tried stopping and starting MySQL several times, but the diagnostic remains.</div>
<div style><br></div><div style>Any suggestions on how to fix this problem?</div><div style><br></div><div style><br></div></div></div></div>