Tag Archive for 'howto'

Cleaning out old stuff in the Mythtv database.

Removing tons of stuff from the Mythtv database can be a bit tedious as there are no multidelete options in the webinterface. This is how I do it.

Launch mythtvfs to read the database as filesystem mythtv. On my box it looks like so:

mythtvfs -o host=192.168.0.7 /mnt/nfs/myth /mnt/test

Now to kill all programs matching “needle” older then 50 days. find /mnt/test -type f -mtime +50 -iname "needle” -exec rm -f {} \;

Now find the and unpack the script find_orphans and run in it to delete the dbentries pointing to the files you just deleted. perl myth.find_orphans.pl --dodbdelete --pass=SECRET --dbhost=192.168.0.7