[mythtv] Problem with DataDirect Migration docs

[David George]

On Mon, 10 May 2004, David Hampton wrote:

> I'm running myth on a FC1 system.  The update to DataDirect was a breeze
> except for the last step in section 21.19 of the FAQ where the channel
> icons are restored.  Because this step attempts to update multiple
> tables, it requires mysql 4.0.4 or better to work.  Is there an
> equivalent command in mysql 3.23?  The command is:
> 
> 	UPDATE channel,channel_copy
> 	  SET channel.icon = channel_copy.icon
> 	  WHERE channel.callsign = channel_copy.callsign;
> 
> Thanks.
> 
> David

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);

I am currently running an old CVS version from a few weeks ago and I don't 
have the channel_copy table.  Is this a new table or just a mysql4'ism for 
creating a temporary table?

HTH,
David