[mythtv-users] Want to re-record Recorded but deleted shows...

[hayward at slothmud.org]

This is exactly the solution I was looking for.  It worked great, thanks 
for being so helpful!

I just did:

mysql> select starttime,title,subtitle from oldrecorded;

and

mysql> delete from oldrecorded where starttime='TIME_OF_SHOW';

--
Brian


On Sat, 13 Dec 2003, cmisip wrote:

>You might be able to do some mysql to delete those shows from your
>oldrecorded table.  Something like:
>
>use mythconverg;
>select * from oldrecorded where title="title";
>
>of course you can use other columns as a filter.
>
>when you find that show then
>
>delete from oldrecorded where title="title";
>
>do a database backup first of course in case something goes wrong.  I
>have not kept up with the latest database changes so this may not work. 
>I dont claim to be an expert either but I have played with the database
>a little bit. So use this advice with caution.
>
>
>
>
>
>
>On Sat, 2003-12-13 at 08:12, Joseph A. Caputo wrote:
>> On Friday 12 December 2003 23:21, hayward at slothmud.org wrote:
>> > 
>> > I recorded several shows and later deleted them while I was playing around 
>> > with my recording settings.  Now I want to make sure the previously 
>> > recorded and deleted shows will actually be recorded the next time they 
>> > come up.  It appears as if they are being skipped because the "record 
>> > duplicates" thing is not selected.
>> > 
>> > See, I don't want to record duplicates - I just want to record the shows 
>> > that have already been recorded but deleted.
>> 
>> Ummm, that's what a duplicate is.  A 'duplicate' in Myth refers to a program 
>> with the same title, subtitle & description that has been recorded at some 
>> point in the past, but has been deleted.  'Duplicate' does not refer to the 
>> same program that is still in your list of available recordings (i.e. hasn't 
>> been deleted).  Turn on the 'record duplicates' option, and Myth will record 
>> the shows without regard to whether they've ever been recorded in the past.  
>> When you've got the shows you want, you can turn the option off if you like.
>> 
>> -JAC
>> 
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>> 
>
>