[mythtv] Problem with DataDirect Migration docs

[David Hampton]

On Tue, 2004-05-11 at 05:09, David George 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);

Thanks.

> 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?

The second step in FAQ 21.19 instructs you to create a new channel_copy
table.

David