[mythtv] How do you delete the database except for recorded videos

[Bruce Markey]

Chris wrote:
> Will this allow me to rebuild the recorded video  database from the
> video files stored on the hard disk if I decide to just delete the whole
> database and start over?  

WAIT!

Before giving it another thought ;-) look at "man mysqldump"
make sure you have a good copy of unrecoverable data before
the thought "just delete the whole database" ever enters your
mind again! (Whew! 8-)

Next, the script is said to match up your files with the
recorded list. It does not do anything about the conflict
list. And, as the author pointed out, you won't have the
titles or description anymore. If you needed to rebuild
the database for some more critical disaster, you could
use the INSERT statments for the 'recorded' table from
your database dump to put back the entries for your files.


Now, the original question was about multiple entries in
the conflict list...

> On Wed, 2003-01-01 at 17:49, Brent Borghese wrote:
> 
>>>I have multiple entries of the same show listed in Fix Recording
>>>conflicts( a show conflicting with itself).  Is there a way to delete
>>>this section of the database?

I've seen this too but it's easily solved without doing
anything drastic. Try this. Go the the EPG and find that
time and channel. Press "i" then select "Don't record this
program". This will remove at least one, but more likely all
of the entries in the conflict list. Next, assuming you do
want to record it, go back and choose the recording method.

Also realize that even though the multiple entries are
wrong, it will still just record the show once and add
one entry to the recorded list so "no harm no foul". If
you were able to find the problem in the source code and
create a patch, that would be ideal but even finding a
reproducible test case might help someone find a fix if
you can show them how to make this happen.

--  bjm