knowledgejunkie at gmail
Nov 30, 2009, 12:00 PM
Post #2 of 2
(496 views)
Permalink
|
|
Re: Remove channel information from Mythtv database?
[In reply to]
|
|
2009/11/30 Mike Dent <mcdent [at] gmail>:
> I've some weird problem with 0.22 where despite me deleting all my
> channels and transports, when I do a new full scan it tells me it
> has found 150+ conflicting channels. This makes me think that perhaps
> if I am able to clear out this information from the database first,
> re-run
> the scan, things might be working better.
>
> So, is there a relatively simple way to clear this data from a sql table(s)?
To remove all of the video source information in mythtv-setup, choose
"Delete All Video Sources" from the Video Sources page.
To remove the channel scanner history in MySQL:
TRUNCATE TABLE channelscan;
TRUNCATE TABLE channelscan_channel;
TRUNCATE TABLE channelscan_dtv_multiplex;
Cheers,
Nick
--
Nick Morrott
MythTV Official wiki: http://mythtv.org/wiki/
MythTV users list archive: http://www.gossamer-threads.com/lists/mythtv/users
"An investment in knowledge always pays the best interest." - Benjamin Franklin
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
|
