<br><br><div><span class="gmail_quote">On 5/26/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>><br>> No, all channel information is in the database in the channel table<br>><br>> (OT note -- I'm trying out the quote feature of g-mail -- just<br>> learning how to use it in this post).
<br>Try to work on bottom posting. Posting replies at the top is frowned upon.<br>><br>> Thanks for the reply -- now I have a different set of questions as a<br>> result:<br>><br>> What purpose does the "scan for channels" serve if all the information
<br>> is in the channel database?<br>Scan for channels populates the frequency information into the database<br>for the channels your provider has. This is unnecessary for US cable<br>channels because their frequencies are standard and hard coded into the
<br>system so it knows what they are. Myth knows, zap2it knows, so it is<br>automatically configured. HDTV or other sources do not have these<br>standard frequencies (ie: channel 2 = X hz) so they must be scanned for.<br>
><br>> Does the database have a filename? Can I run a sed or awk on the<br>> database and correct some errors in the listing info? (The listings<br>> are off by about 4 hours. Haven't truly delved into this issue yet
<br>> and discovered what is wrong -- but the programming info is way off).<br>It is a MySQL database. You should visit <a href="http://www.mysql.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.mysql.com</a> for<br>information on it. A good tool for manipulating the database is
<br>PHPmyadmin (google it) which, if you can install it, provides a web<br>interface for viewing and editing the database tables and information.<br><br>Kevin<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></blockquote><div><br>
<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">Try to work on bottom posting. Posting replies at the top is frowned upon.</blockquote>
<div>Is this better? It certainly makes sense that bottom posting would make for easier reading. Oddly, after clicking "Reply" Goggle's Gmail places the cursor at the top (and above) all other text. <br><br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
It is a MySQL database. You should visit <a href="http://www.mysql.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.mysql.com</a> for<br></blockquote><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
information on it. A good tool for manipulating the database is<br></blockquote><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">PHPmyadmin (google it) which, if you can install it, provides a web
<br></blockquote><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">interface for viewing and editing the database tables and information.</blockquote>
<div>I'll certainly give it a look -- Thanks for all you help. <br><br>To summarize:<br><br>The channel frequency information and broadcast scheduling are in the same MySQL database. Lacking this knowledge is what was causing me to have difficulty "conceptualizing" how Myth stored data. I thought two arrays of data needed to be placed into two separate database files. After a brief look into MySQL I see that one database file may contain several arrays of data.
<br><br>Usually Zap2it populates the database with both sets of data -- as both sets are relatively standardized and known. However, Zap2It is not aware of exactly how local stations utilize their portion of the OTA spectrum. Perhaps they will broadcast one HD signal, or maybe 5 SD signals on the frequency. Therefore MythTV must scan the airwaves in order to "see" how how the local stations are utilizing their bandwidth.
<br><br>Most likely the local stations will broadcast the regularly scheduled network programing, but Zap2it is probably unaware of any additional programing that a station might be broadcasting OTA.
<br></div></div></div><br></div><br>