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.<br>
<br>
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 <span style="font-style: italic;">still</span>
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.<br><br><div><span class="gmail_quote">On 5/26/06, <b class="gmail_sendername">H P Ladds</b> <<a href="mailto:householdwords@gmail.com">householdwords@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div><span class="q"><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">No, all channel information is in the database in the channel table
</blockquote></span></div><div>(OT note -- I'm trying out the quote feature of g-mail -- just learning how to use it in this post).
<br><br>Thanks for the reply -- now I have a different set of questions as a result:<br><br>What purpose does the "scan for channels" serve if all the information is in the channel database?<br><br>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).
<br><br>Andrew might be interested in this topic as well. <br><br>Again thanks, Kevin. Your help genuinely appreciated.<br><br><br></div></div><div><span class="e" id="q_10b7154bd5d9ea0a_3"><br><br><div><span class="gmail_quote">
On 5/25/06, <b class="gmail_sendername">Kevin Kuphal
</b> <<a href="mailto:kuphal@dls.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">kuphal@dls.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
H P Ladds wrote:
<br>> I am currently capturing HDTV OTA, and am having difficulty<br>> conceptualizing the relationship between "scanning for channels" and<br>> importing channel info. using Zap2it.<br>><br>> My assumptions:
<br>><br>> 1. mythtv-setup>Input connections>"scan for channels" uses the capture<br>> card to scan the airwaves for signals. When it finds a signal, Myth<br>> records the information in a .conf file. After the information is
<br>> obtained, Myth references this .conf file and predisposes the capture<br>> card to tune-in a specific channel(s) -- rather than scanning for<br>> channels every time a user wishes to watch or record video content.
<br>No, all channel information is in the database in the channel table.<br>><br>> 2. The "mythfillmydatabase" command downloads a listing of when and on<br>> what channel television programming will occur.
<br>True<br>><br>> 3. Somehow MythTV cross references the info. obtain from Zap2it<br>> "mythfillmydatabase" and From "scan for channels" to facilitate<br>> recording.<br>Yes. An xmltvid is inserted for each channel in the database which
<br>corresponds to the listings information from zap2it.<br>><br>> Put another way, the information obtained from "scan for channels" is<br>> a list of hardware settings that tune in OTA stations. The information
<br>> obtained from Zap2it is a list of channel information. These separate<br>> databases are indexed together to faciltate viewing and recording.<br>><br>> 4. However, when using a cablebox one should not use mythtv-setup's
<br>> "scan for channels" feature. Zap2It's information is used to populate<br>> both (all?) databases.<br>Because from a cablebox or standard cable/antenna source, the channel<br>frequency information is a standard and populated from tables in the
<br>source code. OTA HDTV and other sources do not have this standard<br>mapping and so the frequency information must be scanned for or imported.<br><br>Kevin<br><br><br>_______________________________________________
<br>
mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br></blockquote></div><br>
</span></div></blockquote></div><br>