Category Archives: MythTV Themes

Posts about the MythTV themes I mantain

Build your own MythTV 0.25 packages for Ubuntu Maverick

All you need to do is get yourselft a PPA account and go to the following link:

https://launchpad.net/~mythbuntu/+archive/0.25/+copy-packages

There copy the most current version to your PPA and select Maverick as destination. Now wait for the build to be finished.

With some luck you will find your binaries in your personal PPA. Mine can be found here:

https://launchpad.net/~managementboy/+archive/ppa/+packages

Restoring partial sections of your MythTV database

I sometimes get myself into real trouble by “optimizing” the fields in my MythTV database. Today I managed to overwrite all my descriptions! My backup was two days old, so I had to figure out how to get as much data back as possible. Well here is how to do it:

Do a backup of your broken database just in case!

/usr/share/mythtv/mythconverg_backup.pl

Turn of mythbackend (on Ubuntu)

sudo service mythtv-backend stop

Make a copy of your backup to a directory you want to work in.

cp /var/lib/mythtv/recordings4/mythconverg-1264-20110119213749.sql.gz /tmp/

Then unzip the backup.

gunzip mythconverg-1264-20110119213749.sql.gz

Now extract only those parts of the database you will need. In my case I needed all fields in the “recorded” table of the database.

cat mythconverg-1264-20110119213749.sql |grep "INSERT INTO \`recorded\`" > out

Now delete all the old entries in the database up to the date/time of your backup.

mysql --default_character_set utf8 -umythtv -p mythconverg -e "DELETE FROM mythconverg.recorded WHERE recorded.starttime < '2011-01-19 21:37:49'"

Lastly import all the old fields to the database.

mysql --default_character_set utf8 -umythtv  -p mythconverg < out

Willi theme in version 1.9

Quiet a few fixes and cosmetic improvements. Recording screen now has a nicer bookmark icon, ratings are shown as actual stars, transcoded state was added, date and time of selected recording is now shown in two distinct locations. The template for description was fixed and one more line of the description is now shown. The three types of possible subtitle states are now themed (not tested, as this is not provided by my grabber). Get version 1.9 of the Willi theme here.