[mythtv-users] Database Structure

Michael T. Dean mtdean at thirdcontact.com
Thu May 20 05:38:59 UTC 2010


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


More information about the mythtv-users mailing list