[mythtv-users] update database from 0.7 to 0.9.1

[Bruce Markey]

Joseph A. Caputo wrote:
>>-----Original Message-----
>>From: mythtv-users-bounces at snowman.net
>>[mailto:mythtv-users-bounces at snowman.net]On Behalf Of Harondel J. Sibble
>>Sent: Friday, June 20, 2003 3:16 AM
>>To: Discussion about mythtv
>>Subject: Re: [mythtv-users] update database from 0.7 to 0.9.1
>>
>>
>>Just curious about one other thing, I seem to have some left over
>>recordings
>>in the database. I actually deleted the nuv files before doing
>>the upgrade,
>>however they still show up in the list of recorded programs.
>>Short of editing
>>the database directly is there a much easier method to clear
>>these orphans
>>out?
> 
> 
> You could 'touch' an empty file with the appropriate name, which would allow
> you to then delete it from the 'Delete Recordings' screen.  Of course, you'd
> have to go into the database to find the appropriate filename (though you
> could construct the name yourself if you know the video source, chanid,
> starttime & endtime).

Or, try to play them then cut'n'paste the filename from the
error message on the console.

Changing from None to None
Error: /video/mythtv/1010_20030617200000_20030617220000.nuv file not found
...
$ touch /video/mythtv/1010_20030617200000_20030617220000.nuv


If you really have zero .nuv files, you could backup your
database:

http://www.mythtv.org/docs/mythtv-HOWTO-19.html#ss19.6

then empty your 'recorded' table:

mysql -u mythtv -pmythtv mythconverg
mysql> delete from recorded;

--  bjm