[mythtv-users] How to delete encoders from mythtv database

Albert Graham agraham at g-b.net
Mon May 12 01:27:32 UTC 2008


Mike,

Well, thanks for that, looks like it should solve the problem, will give 
it a go.

Thanks again.

Albert.



Michael T. Dean wrote:
> On 05/11/2008 06:57 PM, Albert Graham wrote:
>   
>> That thread assumes a perfect world, my database seems to have lots of 
>> configurations for lost of hostnames
>> get duplicate key errors when I run that sql.
>>
>> Is it possible to clean up the databases and remove any references to 
>> non-existing host names, if so how ?
>>   
>>     
>
> Spring cleaning:  http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
>
> Basically, first, make sure you have a backup of the "most-working" 
> state of the database.  Then, drop the DB, then run mc.sql, then start 
> and exit mythtv-setup (allowing it to upgrade the database).  Then, 
> follow the instructions in the link above (ideally using the 
> new-hostname database backup on which you ran the new-hostname sed 
> commands).  If everything imports correctly (i.e. without duplicate key 
> errors), you're good to go (and begin to reconfigure your Myth box with 
> mythtv-setup, then mythfrontend settings).
>
> If the 23.7 tables don't import cleanly, let me know and I'll give you a 
> more involved process.
>
>   
>> Also, I don't think this is the root of my problem, because every single 
>> other function works, including TV listings and watching and recording 
>> from TV ?
>>     
>
> I think the current state of the database is the root of the problem.  
> How it got into the current state isn't too important.  Just do as 
> above, and it should fix it.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   



More information about the mythtv-users mailing list