[mythtv-users] SchedulesDirect Changes

[R. G. Newbury]

On 18/09/14 05:38 PM, Tom Dexter wrote:
> On Thu, Sep 18, 2014 at 5:34 PM, Rich Freeman
> <r-mythtv at thefreemanclan.net> wrote:
>> On Thu, Sep 18, 2014 at 5:16 PM, R. G. Newbury <newbury at mandamus.org> wrote:
>>> The sources and structures are different, and neither 'knows' anything about
>>> the other. Hence the requirement for (re)creating your lineups and linking
>>> to your Capture Cards on the new server.
>>>
>>
>> Are the program/episode IDs the same, or will we have to re-create all
>> our recording schedules after creating lineups/etc.
>>
>> It probably wouldn't hurt to put together a migration guide on the
>> wiki before the switchover...
>>
>> --
>> Rich
>
> Agreed.  Another question I'd have is, on an existing OTA setup, can
> the existing channels be used?  All my experiences with scanning
> channels, even a few recent ones where PIDs changed etc, has been
> nothing short of a nightmare.  I've been running my system for seven
> year and have never had to delete a video source.  Does that delete
> the associated channels?

You could try keeping your channels, but doing soi would require some 
mysql data-diving.
At the minimum, you would have to create the new lineup, (without 
deleting the old one),then change the sourceid field in (at least) the 
channel table, from the old sourceid number to the new number, after 
having deleted all entries with the new number beforehand (ie, delete 
what listings you have just created),

NO IDEA, NOT AN INKLING about what else might need to be changed in 
other tables. But whereever sourceid appears (except in videosource) you 
may need to change the field value.

At a minimum, you would want to start with a number of mysqldump backups 
of individual tables, so you could restore them *over* the new table. 
And your karma exceedingly well centred.  I suspect that this will be 
long and painful process.

I have never had any problems with scanning, so long as the card is 
properly set up. Or are you talking about scanning on a cable setup?
We don't need to do that anymore except for unencrypted QAM services 
(which are non-existent in Canada, and extremely rare in the US ofA).

Maybe it's time for a new OTA tuner?

> Also, does anyone know if Joseph is correct in the above post, that
> the XML service will continue to work?  That would certainly change
> the level of urgency on all this.

No the XML service is going away in November. That is why the new 
grabber is necessary.


-- 
              R. Geoffrey Newbury