[mythtv-users] Difficulty conceptualizing the relationship of Zap2it data and scanning for channels.

[Andrew Kuan]

Everything's stored in mysql. The database name is "mythconverg" and the
table name is "channel". You'll need to execute SQL queries in order to
correct listing information. I'd back up your DB first if you're going to
start futzing with it. Usually I just stop mysql and then tar up the
/var/lib/mysql/mythconverg directory.

By the way, last night I deleted everything in my program table and then
reran mythfilldatabase. The shows all got repopulated in the program table
properly but the channel names/callsigns still weren't updated. Strange
thing is that, when I'm running mythfilldatabase, it says it's updating
channel information. Anyway, I went into MythWeb and manually entered
callsign and channel name information.

On 5/26/06, H P Ladds <householdwords at gmail.com> wrote:
>
> No, all channel information is in the database in the channel table
>
> (OT note -- I'm trying out the quote feature of g-mail -- just learning
> how to use it in this post).
>
> Thanks for the reply -- now I have a different set of questions as a
> result:
>
> What purpose does the "scan for channels" serve if all the information is
> in the channel database?
>
> Does the database have a filename? Can I run a sed or awk on the database
> and correct some errors in the listing info? (The listings are off by about
> 4 hours.  Haven't truly delved into this issue yet and discovered what is
> wrong -- but the programming info is way off).
>
> Andrew might be interested in this topic as well.
>
> Again thanks, Kevin. Your help genuinely appreciated.
>
>
>
>
> On 5/25/06, Kevin Kuphal <kuphal at dls.net> wrote:
> >
> > H P Ladds wrote:
> > > I am currently capturing HDTV OTA, and am having difficulty
> > > conceptualizing the relationship between "scanning for channels" and
> > > importing channel info. using Zap2it.
> > >
> > > My assumptions:
> > >
> > > 1. mythtv-setup>Input connections>"scan for channels" uses the capture
> > > card to scan the airwaves for signals. When it finds a signal, Myth
> > > records the information in a .conf file. After the information is
> > > obtained, Myth references this .conf file and predisposes the capture
> > > card to tune-in a specific channel(s) -- rather than scanning for
> > > channels every time a user wishes to watch or record video content.
> > No, all channel information is in the database in the channel table.
> > >
> > > 2. The "mythfillmydatabase" command downloads a listing of when and on
> > > what channel television programming will occur.
> > True
> > >
> > > 3. Somehow MythTV cross references the info. obtain from Zap2it
> > > "mythfillmydatabase" and From "scan for channels" to facilitate
> > > recording.
> > Yes.  An xmltvid is inserted for each channel in the database which
> > corresponds to the listings information from zap2it.
> > >
> > > Put another way, the information obtained from "scan for channels" is
> > > a list of hardware settings that tune in OTA stations. The information
> >
> > > obtained from Zap2it is a list of channel information. These separate
> > > databases are indexed together to faciltate viewing and recording.
> > >
> > > 4. However, when using a cablebox one should not use mythtv-setup's
> > > "scan for channels"  feature. Zap2It's information is used to populate
> > > both (all?) databases.
> > Because from a cablebox or standard cable/antenna source, the channel
> > frequency information is a standard and populated from tables in the
> > source code.   OTA HDTV and other sources do not have this standard
> > mapping and so the frequency information must be scanned for or
> > imported.
> >
> > Kevin
> >
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060526/3253c29b/attachment.htm