[mythtv-users] USA OTA FCC frequency rescan?

[Justin Alcorn]

Once you create the file with the sql statements, do:

mysql -u [mythtvusername] -p mythconverg < [sqlcommandsfilename]

it'll prompt for the database password
-- 
Justin B. Alcorn
The views expressed are not necessarily my own, much less anyone else's
PGP Fingerprint CCEB F776 C3FD 1050 C8DB  532E B8B9 BED7 7764 406C


On Tue, Aug 13, 2019 at 6:56 AM James Abernathy <jfabernathy at gmail.com>
wrote:

>
> On 8/12/19 10:27 PM, Justin Alcorn wrote:
>
> We just had that warning, these steps are what got it working for me.
> --
> Justin B. Alcorn
> The views expressed are not necessarily my own, much less anyone else's
> PGP Fingerprint CCEB F776 C3FD 1050 C8DB  532E B8B9 BED7 7764 406C
>
>
> On Mon, Aug 12, 2019 at 10:22 AM Jay Harbeston <jharbestonus at gmail.com>
> wrote:
>
>>
>>
>> > On Aug 12, 2019, at 9:13 AM, James Abernathy <jfabernathy at gmail.com>
>> wrote:
>> >
>> > So my local OTA channels have started the warning about September 6 and
>> doing a rescan to continue receiving their channels.
>> >
>> > My backend is mythtv v30 with 2 tuner systems.  One is a PCIe card, the
>> HAUPPAUGE WinTV-quadHD PCI Express TV Tuner Card 1609. The other is a
>> SiliconDust HDHomerun Quatro.
>> >
>> > I currently get my EPG from SchedulesDirect via
>> tv_grab_zz_sdjson_sqlite. The Input Connections for both sets of tuners,
>> i.e. 8-tuners, use the same Video Source which is the one setup to use
>> tv_grab_zz_sdjson_sqlite.
>> >
>> > Can someone point me to instructions or discussion on what to do in my
>> case? I think the rescan is done externally to mythtv-setup using steps
>> defined at https://www.mythtv.org/wiki/XMLTV for initial setup, but I
>> remember that if not careful you can loose Recording rules and previously
>> recorded metadata is some cases.
>> >
>> > Has anyone worked out a way to do the rescan without messing things up??
>> >
>>
>> I will be doing the following steps:
>>
>> 1. mythconverg_backup.pl —backup_xmltvids  — # Sometime between now and
>> when channels  change.
>>     The created file contains two different formats, the first being a
>> series of update statements using only callsign:  e.g.
>>
>>     UPDATE channel SET xmltvid = 'I17155.json.schedulesdirect.org' WHERE
>> callsign = 'Channel 4’;
>>
>> The remainder are commented out.
>>
>> After the change has been made, do the following:
>>
>> 2. Stop mythbackend
>> 3. Start mythtv setup
>> 3.1:  Clear all the OTA channels currently setup.
>> 3.2. Rescan all OTA channels
>> 3.3  Exit mythtv setup
>> 4.  Run the sql update statements generated above.
>> 5.  Start mythbackend
>>
>> Regards!
>>
>>
>>
>> I did the --backup_xmltvids and looked at the file. Sort of understand
> what it does.  I'm not sure how to run this in step #4.
>
> Jim A
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190813/13ae6942/attachment.html>