KnoppMyth DST Update

Although I was diligent to update my Pocket PC for the new Daylight Savings Time, I failed to update my KnoppMyth MythTV box. Fortunately, I didn’t miss any recordings. Here’s my update instructions.

I am currently running version “Release 5 Delightful 1” so, I’m one version behind, but I would assume the latest has been patched (currently Release 5 Eulogy 50 as of this writing.)

I basically stole most of this from this awesome LinuxDevices.com article, which explains how to update a “generic” Linux distribution.

Make a temp folder
mkdir tzdata; cd tzdata

Grab the new timezone files from here:
wget ftp://elsie.nci.nih.gov/pub/tzdata2007c.tar.gz

Unpack the files
tar -xzvf tzdata2007c.tar.gz

Convert the files:
zic -d zoneinfo northamerica

Copy them over the existing files:
cp -r -f --reply=yes zoneinfo/* /usr/share/zoneinfo/

Link /etc/localtime to the proper time zone. Make sure to use the new files in the “America” subfolder. The old ones are in “US.” Don’t ask me why.
ln -fs /usr/share/zoneinfo/America/Detroit /etc/localtime

Check to make sure you see March 11.
zdump -v /etc/localtime EST5EDT |grep 2007
Replace EST5EDT with your time zone, if different. Central: CST6CDT; Mountain: MST7MDT; Pacific: PST8PDT.

Next, you can manually restart the Myth backend:
/etc/init.d/mythtv-backend restart

You’ll probably also want to just restart your system to make sure all the services update with the new time zone.

After that all works, you’ll want to dump the MythTV program listings and refill the database. You can do this by executing the following mysql command:
delete from program;
then run:
mythfilldatabase