[mythtv-users] Restoring channel icons (was Re: MythTV CVS & DataDirect - Success!)

[Romain Kang]

> mysql> UPDATE channel,channel_copy SET channel.icon=channel_copy.icon 
> WHERE channel.callsign=channel_copy.callsign;
> 
> ERROR 1064: You have an error in your SQL syntax near 'channel_copy SET 
> channel.icon=channel_copy.icon WHERE channel.callsign=channel_c' at line 1
> 
> Anyone have success with this?

OK, for MySQL 3.x, this seemed to populate the channel DB for me:

% mysql -u<user> -p<password> mythconverg
SELECT chanid, icon FROM channel_copy WHERE LENGTH(icon) > 0 INTO OUTFILE 'chanico.out';
bye;

% awk '{ print "UPDATE channel SET icon=\"" $2 "\" where chanid=" $1 ";" }'  chanico.out > chanout.sql
 
 % mysql mythconverg < chanout.sql