I've been using mysql CLI for years so I prefer it. Here's how I do it
(I have no root password set on the database). Disclaimer (like the
Windows registry warning): you could really mess things up if you make
a mistake so backup the database first.
mysql -u root mythconverg
describe channel; (shows all fields available in channel table)
The fields I like to use are listed with the following command. It gives
me a concise comparison of all channels for callsign KCPQ:
select chanid,channum,freqid,sourceid,callsign,name,xmltvid,recpriority
from channel where callsign like "%KCPQ%" order by convert(channum,integer);
Then, to set a priority:
update channel set recpriority=5 where chanid=6131;
I like to use chanid since the channum is a string and can be 13-1 or
13.1 or anything you or the grabber set it to.
exit; (exit the mysql cli)
There is also an interface via mythweb, but I'm not very familiar with it.
Dave D.
On 5/27/20 7:02 AM, Stephen Worthington wrote:
> On Wed, 27 May 2020 06:11:54 -0700, you wrote:
>
>> On 5/26/20 8:17 PM, Stephen Worthington wrote:
>>> On Tue, 26 May 2020 15:55:46 -0700, you wrote:
>>>
>>>> I am using MythTV 0.28. I would like to change the recording priority
>>>> for one of my channels.
>>>>
>>>> For example, I have two different channels with the same call sign, and
>>>> I would like to raise the priority on one of them to prefer using it
>>>> instead of the other channel.
>>>>
>>>> I looked at the wiki
>>>> (https://www.mythtv.org/wiki/Scheduling_Recordings), but when I go to
>>>> the Recording Priorities->Channel Priorities configuration, it does not
>>>> show the associated channel numbers, only the call sign. I cannot tell
>>>> one channel from another.
>>>>
>>>> Is there some mysql query that I can use to manually configure this?
>>>>
>>>> Jay
>>> You certainly could set the individual channel priorities using SQL
>>> commands, but there is no need as they are available in the
>>> mythtv-setup GUI. You can adjust them without shutting down
>>> mythbackend. On Ubuntu, where mythtv-setup is a script that runs
>>> mythtv-setup.real, go to a command prompt running as your frontend
>>> user and run mythtv-setup.real. When mythtv-setup.real asks to stop
>>> mythbackend, tell it no. Then on v30 I would do this:
>>>
>>> 6. Channel Editor > select the channel you want > Enter > Channel
>>> Options - Common > Scroll down to Priority (it is off the bottom of
>>> the screen)
>>>
>>> In 0.28 it will be a little different, but you can select the
>>> individual channels by number and the Priority setting should be
>>> there.
>>>
>> Thanks, This method seemed to work. I ended up using the MythTV
>> Backend Setup to do this and I needed to stop the backend and restart it
>> to get it to reschedule using the changed channel priority.
>> Jay
> Getting the scheduler to run again is easy:
>
> mythtutil --resched
> _______________________________________________
> mythtv-users mailing list
> mythtv-users@mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users http://wiki.mythtv.org/Mailing_List_etiquette MythTV Forums:
https://forum.mythtv.org