I did a stupid thing and restored an old backup and now I am missing about 2 months of recorded shows in Myth. I found myth.rebuilddatabase.pl and it looks like it will do what I want. I tried this:

myth.rebuilddatabase.pl --user mythtv --pass mythtv --dir /mnt/video/TV --host localhost

and I get the following error:
DBI connect('database=mythconverg;host=tv','mythtv'....) failed; Can't connect MySQL server on 'tv' (111)at /usr/local/bin/myth.rebuilddatabase.pl line 120 Cannot connect to database ()

Line 120 in myth.rebuilddatabase.pl is:
'pass='=>\#pass, (or some such, its hard to read on the tv screen;)

Any ideas?

Thanks for the help.

Rob

I suspect the problem is something to do with your machine's network setup, because it is getting the name 'tv' when you specify 'localhost'.

What happens if you do: (maybe with --dir /mnt/video/TV if that is needed due to reconfig)

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club

I tried using that script after upgrading to r5d1, and it failed totally because it was looking only for .nuv files (line #193). I attempted to quickly modify it (clearly it is no longer good for recent upgrades).

I'm going to work on a newer version that uses bash, sed, awk and mysql client. I'll post it when it's done.

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************

There is (or used to be) an option to tell it what file types to look for...

Searching for the name of the script should turn up a thread with the details. There have been 2-3 recently.

Yes, KnoppMyth currently has an old version. For now, grab the latest from here:

http://cvs.mythtv.org/trac/browser/bran ... format=raw

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club

Darn. Someone beat me to it. I fixed it tonight.

Incidentally, the nuv format not only had the different extension, but the files also had start *and end* times in the file name. This also tripped up the perl script, since it extracted this data from the name then stuck it into the database.

Nice little script Saves bucket loads of time. I previously copied all the tv files into the video directory then rename them. Very tedious indeed!

Mike

_________________
*********************
LinHES 7.4
Australian Dragon
*********************