[mythtv-users] Anyone in UK - Don't forget to do your DVB-T retune today.

[Simon Hobson]

Mike Holden wrote:
>Still faffing about here! Can anyone recommend their quick and easy solution to
>retuning freeview in the UK for MythTV?

Delete all channels first, then do a full scan. In the past I've sometimes found the first scan failed to pick up some channels (but our reception is poor at times) so a second scan has been needed.

Then run my little script to reset the channel numbers and xmltv id's before starting the backend again. Oh yes, and rename ITV to "ITV2 +1".

A manual run of mythfilldatabase was required as about a third of the channels had no guide data.

My script is :

#!/bin/bash

# Set MythTV channel numbers

. ~/.mythtv/mysql.txt

echo '
  update channel set channum=channum+1000 where channum < 1000 ;
  update channel set visible=0 ;
  update channel set visible=1,channum=1,xmltvid="north-west.bbc1.bbc.co.uk" where callsign="BBC ONE" ;
  update channel set visible=1,channum=2,xmltvid="north-west.bbc2.bbc.co.uk" where callsign="BBC TWO" ;
  update channel set visible=1,channum=3,xmltvid="bbcthree.bbc.co.uk" where callsign="BBC THREE" ;
  update channel set visible=1,channum=4,xmltvid="bbcfour.bbc.co.uk" where callsign="BBC FOUR" ;
  update channel set visible=1,channum=5,xmltvid="granada.itv1.itv.co.uk" where callsign="ITV1" ;
  update channel set visible=1,channum=6,xmltvid="itv2.itv.co.uk" where callsign="ITV2" ;
  update channel set visible=1,channum=7,xmltvid="tsod.plus-1.itv2.itv.co.uk" where callsign="ITV2 +1" ;
  update channel set visible=1,channum=8,xmltvid="itv3.itv.co.uk" where callsign="ITV3" ;
  update channel set visible=1,channum=9,xmltvid="itv4.itv.co.uk" where callsign="ITV4" ;
  update channel set visible=1,channum=10,xmltvid="channel4.com" where callsign="Channel 4" ;
  update channel set visible=1,channum=11,xmltvid="tsod.plus-1.channel4.com" where callsign="Channel 4+1" ;
  update channel set visible=1,channum=12,xmltvid="e4.channel4.com" where callsign="E4" ;
  update channel set visible=1,channum=13,xmltvid="tsod.plus-1.e4.channel4.com" where callsign="E4+1" ;
  update channel set visible=1,channum=14,xmltvid="more4.channel4.com" where callsign="More 4" ;
  update channel set visible=1,channum=15,xmltvid="filmfour.channel4.com" where callsign="Film4" ;
  update channel set visible=1,channum=16,xmltvid="channel5.co.uk" where callsign="Five" ;
  update channel set visible=1,channum=17,xmltvid="fiveusa.channel5.co.uk" where callsign="Five USA" ;
  update channel set visible=1,channum=19,xmltvid="fiver.channel5.co.uk" where callsign="FIVER" ;
  update channel set visible=1,channum=20,xmltvid="dave.uktv.co.uk" where callsign="Dave" ;
  update channel set visible=1,channum=21,xmltvid="tsod.plus-1.dave.uktv.co.uk" where callsign="Dave ja vu" ;
  update channel set visible=1,channum=22,xmltvid="1.virginmedia.com" where callsign="Virgin1" ;
  update channel set visible=1,channum=23,xmltvid="tsod.plus-1.freeview.1.virginmedia.com" where callsign="Virgin1+1" ;
  update channel set visible=1,channum=24,xmltvid="sky-three.sky.com" where callsign="SKY THREE" ;
  update channel set visible=1,channum=25,xmltvid="news.bbc.co.uk" where callsign="BBC News" ;
  update channel set visible=1,channum=26,xmltvid="freeview.history.uktv.co.uk" where callsign="UKTV History" ;
  update channel set visible=1,channum=27,xmltvid="freeview.yesterday.uktv.co.uk" where callsign="Yesterday" ;
  update channel set visible=1,channum=100,xmltvid="" where callsign="BBC R5L" ;
' | mysql --database=${DBName} --user=${DBUserName} --password=${DBPassword}

-- 
Simon Hobson

Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed
author Gladys Hobson. Novels - poetry - short stories - ideal as
Christmas stocking fillers. Some available as e-books.