Chris Farris - Geeklog

MythTV Rebuild

Posted on January 27th, 2007 by Chris Farris.
Categories: MythTV.

Wow, MythTV is a pain in the ass to build. Luckly I found a site that had OpenSuSE 10.2 rpms. That made it easier. I still had to copy over my config files from the old MythTV build.

http://packman.iu-bremen.de/suse/10.2

I had to manually alter the recording tables to copy the data from the old system to the new database.

The following query was used to compare settings from the old settings table and the new settings table:
select mythconverg.settings.value, mythconverg.settings.data, mythOLD.settings.data from mythconverg.settings, mythOLD.settings WHERE mythconverg.settings.value=mythOLD.settings.value AND mythconverg.settings.data != mythOLD.settings.data INTO OUTFILE '/tmp/setting.diff';

0 comments.