[mythtv-users] Moving xmltv data 1 hour back on one channel

[Simon Hobson]

Could you do it manually with a script ?

Just a simple script that is triggered after a grabber run and does something along the lines of :
select ... , (time - 1 hour) as time, 'y' as channel, ... from listingstable where channel = 'x' into temp ;
delete from listingstable where channel = 'y' ;
insert into listings select * from temp ;
And calls mythbackened to trigger a reschedule.

I'll leave it to someone who's not very rusty with SQL (and familiar with MySQL) to work out the right syntax.