[mythtv] Problem with DataDirect Migration docs

[Anduin Withers]

These are only temporary solutions, is anyone looking into making a more
permanent solution? For example starting a mapping of call signs to network
to icon locations?

A number of people who start adopting at .15 will be in a position where
they may have never run the xmltv grabber, not to mention the current
migration option will only be good until your provider decides to alter
their lineup.

-- 
Anduin Withers


> -----Original Message-----
> From: mythtv-dev-bounces at mythtv.org [mailto:mythtv-dev-bounces at mythtv.org]
> On Behalf Of James Armstrong
> Sent: Wednesday, May 19, 2004 10:53 AM
> To: Development of mythtv
> Subject: Re: [mythtv] Problem with DataDirect Migration docs
> 
> Robert Kulagowski wrote:
> 
> >>> I haven't updated yet and don't know if this will work in mysql3,
> >>> but this should work as long as there is a channel_copy table:
> >>>
> >>> update channel
> >>> set icon = (select distinct icon from channel_copy
> >>>             where channel.callsign = channel_copy.callsign);
> >>
> >>
> >> Has anyone still running MySQL 3 tried this and had it work
> >> correctly? I'll include it if I get some feedback that this is doing
> >> the Right Thing.
> >
> >
> With some trial and error we (David and James) have found that users of
> MySQL 3 can import the icons from the channel_copy table using the
> following steps:
> 
> 1) Follow the faq to copy the channel table into channel_copy then
> complete the DataDirect upgrade.
> 
> 2) Run mysql as root and save the icons and callsigns in to a text file
> using the following commands:
> 
>      mysql -uroot -p mythconverg
>      select callsign, icon from channel_copy where icon <> '' into
> OUTFILE '/tmp/icons.sql';
>      exit;
> 
> 3) Parse the text file that was saved from MySQL so it can be imported
> into the original channel table using the following command:
> 
>     sed -e 's/\(^.*\)\t\(.*\)/UPDATE channel SET icon="\2" WHERE
> callsign="\1";/' /tmp/icons.sql  > /tmp/upd_icon.sql
> 
> 4) Import the parsed and formatted text file back into the channel table
> using MySQL as follows:
> 
>     mysql -umythtv -pmythtv mythconverg < /tmp/upd_icon.sql
> 
> - James
> 
> _______________________________________________
> mythtv-dev mailing list
> mythtv-dev at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev