[mythtv-users] Database Structure

Brent Bolin brent.bolin at gmail.com
Thu May 20 12:49:51 UTC 2010

On Thu, May 20, 2010 at 12:38 AM, Michael T. Dean
<mtdean at thirdcontact.com> wrote:
> On 05/20/2010 01:20 AM, Douglas Peale wrote:
>> On 05/19/2010 09:01 PM, DaveD wrote:
>>> Comcast keeps moving channels around on me.  I have to rescan and
>>> manually update xmltv ID and channel numbers every time they move
>>> stuff.  This time they've only moved a single channel (105, HD version
>>> of 5) and I'd like to just update that info.  If I do a complete rescan,
>>> I'm starting from scratch with all channels so I want to just update
>>> that channel but I don't know how the database stores the info.  There
>>> are lots-O-tables with lots-O-fields.
>>> I have a system I use for playing around and experimenting and I did a
>>> scan on that system just to make sure that 105 was still actually
>>> available.  It is, and the clear QAM HD channel shows up as 5_1 and
>>> plays fine (just like it used to on my real system before they moved
>>> it).  So now I have all the info I need to fix the broken database
>>> exported from my test system.  I'm looking for enough information to
>>> figure out what fields from the test database I should import into the
>>> regular system's database to get 105 working like 5_1 from the test
>>> system.
>>> Is there a comprehensive, definitive guide/document somewhere
>>> (preferably up-to-date) that explains all the tables and fields and what
>>> they are used for and how they interact?  What is freqid, mplexid, etc?
>>> What's the channelscan_channel table used for?  I'd really rather learn
>>> to "fish" (to really understand the database schema), if I can find
>>> enough info somewhere.  I know, I can always download the source....
>> Since you know the frequency ID, just rescan that channel (set the start
>> channel and end channel to that frequency ID). This may
>> affect a few other channels on the same frequency, but fixing that up is a
>> lot less trouble than a complete rescan. Messing with
>> the data base directly is much more trouble, and more risky.
> Yes, and use mythtv-setup channel editor to update the xmltvid, channel
> number, callsign, and name.
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Using Mythweb channel editor live does the same thing correct?

More information about the mythtv-users mailing list