[mythtv-users] corrrupted channel database with Mythtv .10 and xmltv .5.14

Bruce Markey bjm at lvcm.com
Thu Jul 3 18:44:23 EDT 2003


mojo wrote:
>  >
> 
>> You were using cvs, so you need to upgrade with cvs.sql whenever that 
>> file is changed.  You didn't do that, so things broke.
>>
>> Isaac
> 
> 
> already did.. and re-running it with -f just gives the expected errors:
> minimojo database # mysql -f -u root -pspatula < cvs.sql
> ERROR 1060 at line 18: Duplicate column name 'hue'
> ERROR 1060 at line 20: Duplicate column name 'freqid'
> ERROR 1060 at line 23: Duplicate column name 'rank'
> ERROR 1060 at line 24: Duplicate column name 'rank'
> ERROR 1060 at line 26: Duplicate column name 'category'
> ERROR 1060 at line 27: Duplicate column name 'category'
> ERROR 1060 at line 28: Duplicate column name 'category'
> ERROR 1060 at line 30: Duplicate column name 'category_type'
> 
> i'll just drop the whole darn thing and be done with it (hopefully)... i 
> think one of those sql scripts will put the files in var/video back into 
> recorded programs (without the names) and thats fine...

TIME OUT!

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

First, make sure you have a frest dump of your database before
you drop anything. If you lose your 'recorded' table, you can
then simply cut'n'paste the "INSERT INTO recorded ..." lines
and get your listings of recordings back. Pretty much everything
else important in the database can be regenerated.

There is a script to make entries for the files in your directory
but it won't know any of the titles or descriptions. It just
makes unknown entries so you can at least get to them.

--  bjm





More information about the mythtv-users mailing list