[mythtv-users] Cleaning up /var/lib/mythtv

[Shaun Jackman]

Thanks Ron, your trick worked very well. For a lark I also wrote a
short shell script to list the nuv files that mythtv has forgotten
about:

[mythforgotten]
#!/bin/sh
cd /var/lib/mythtv
for i in `mysql -u mythtv --password=mythtv mythconverg -e \
		'select chanid, starttime, endtime from recorded' |
	perl -wne 'next if $. == 1; s/|//g; s/-//g; s/://g; @_ = split;
		print join( '_', $_[0], $_[1].$_[2], $_[3].$_[4]) . ".nuv\n";'` \
	`ls *.nuv`;
	do echo $i; done | sort | uniq -u | xargs du -sh | grep nuv$

and if you like, here's the companion script, which lists the nuv
files that myth does know about:

[mythls]
#!/bin/sh
cd /var/lib/mythtv
mysql -u mythtv --password=mythtv mythconverg -e \
	'select chanid, starttime, endtime from recorded' |
perl -wne 'next if $. == 1; s/|//g; s/-//g; s/://g; @_ = split;
	print join( '_', $_[0], $_[1].$_[2], $_[3].$_[4]) . ".nuv\n";' |
sort | xargs du -sh

Cheers,
Shaun


On Fri, 26 Nov 2004 14:35:35 -0500, Ron Pool <amp1ron at gmail.com> wrote:
> I don't know of a tool to do that, but what I've done in the past is
> delete the .png
> files from the recordings directory, then go back into mythfrontend and arrow
> down through all of the know recordings.  That recreates a new .png file for
> each known recording.  I then deleted all of the .nuv files that didn't have a
> corresponding .png file.  By the way, I did this with mythfrontend set up to
> have the browser show a frame from the start of the movie, not a clip.