[mythtv-users] Deleting a video source

[Tom Walsh]

Pete Cable wrote:

>I *believe* you can run mythsetup and answer "yes" to the clear
>channel lineup question. Then just add your new video source and
>associate it with your tuner card. Voila!
>
>  
>
Yeah, well, it had deleted the video source, but not the channels.  I 
had ended up with a new video source with duplicated channels (from the 
old video source). The only way I could get rid of the extra channels 
assigned to the video source was to create a blank database, populate it 
with a video source, get the lineup data, and then manually patch 
databases together.

It should not have happened...

TomW

>Pete
>
>
>On Sun, 10 Oct 2004 02:40:45 -0400, Tom Walsh <tom at openhardware.net> wrote:
>  
>
>>Shawn wrote:
>>
>>    
>>
>>>I've had to take drastic measures to correct some issues with my channel
>>>lineup, and I would like to undo some of it. Let me explain.
>>>
>>>Comcast recently introduced the anarchy system in their efforts to
>>>organize their channel lineup which myth did not correct with subsequent
>>>mythfilldatabase runs pulling from the datadirect service. Though
>>>datadirect was correct in that it listed the new channel numbers for the
>>>stations who got relocated, the database continued to show the old ones.
>>>
>>>I then created a new video source and assigned that to my ivtv card, ran
>>>mythfilldatabase, and all is well... Well, except that nuisance of an
>>>old video source lying around.
>>>
>>>
>>>      
>>>
>>Apparently, mistakes are not permitted. :P
>>
>>I had a similar problem when upgrading from 0.14 to 0.15.  The old
>>database was whacked somehow when attempting to use it with 0.15.
>>Through dumping the database into a text file (mysqldump mythconverg >
>>mythconverg.old), blowing away the mythconverg database (echo "drop
>>database mythconverg;" | mysql).  I then created a new database (cat
>>mc.sql | mysql -u root), created the correct entries by running
>>mythsetup, dumped that database into another text file, patched the two
>>together by replacing the offending entries with correct ones. (vi).
>>Finally, blew the database out again, created a blank one again (mc.sql)
>>and filled it with the correct info (cat mythconverg.edit | mysql -u root)
>>
>>A lot of gyrations, but it is certainly nice to be using a database that
>>will easily import / export via ascii text!
>>
>>TomW
>>
>>    
>>
>>>One wonders how one is supposed to delete the old one... Anyone know?
>>>
>>>
>>>------------------------------------------------------------------------
>>>
>>>_______________________________________________
>>>mythtv-users mailing list
>>>mythtv-users at mythtv.org
>>>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>
>>>
>>>      
>>>
>>--
>>Tom Walsh - WN3L - Embedded Systems Consultant
>>http://openhardware.net, http://cyberiansoftware.com
>>"Windows? No thanks, I have work to do..."
>>----------------------------------------------------
>>
>>_______________________________________________
>>mythtv-users mailing list
>>mythtv-users at mythtv.org
>>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>>    
>>
>
>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>  
>


-- 
Tom Walsh - WN3L - Embedded Systems Consultant
http://openhardware.net, http://cyberiansoftware.com
"Windows? No thanks, I have work to do..."
----------------------------------------------------