[mythtv-users] Deleting a video source

[Tom Walsh]

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..."
----------------------------------------------------