[mythtv-users] Switching to DataDirect
Gregorio Gervasio, Jr.
gtgj at pacbell.net
Thu May 27 04:44:08 EDT 2004
>>>>> Robert Kulagowski writes:
[migration in MySQL v3]
> Yes, I think I screwed up when I pasted it. Try:
> mysql> create table channel_temp
> select c.chanid, c.channum, c.sourceid, c.callsign, c.name, cb.icon,
> c.finetune, c.videofilters, c.xmltvid, c.contrast, c.brightness,
> c.colour, c.freqid, c.recpriority, c.hue, c.tvformat,
> c.commfree, c.visible, c.outputfilters
> from channel c
> left join channel_copy cb on (c.callsign = cb.callsign);
In my channel table, "hue" is before "freqid". However, I
just tried with a fresh database and the default is yet another column
order. I guess the bottom line is, anyone running this command should
check their existing column order and adjust the command if necessary.
(Unless someone can come up with a better MySQL v3 command?)
Also, wouldn't you want to preserve as much of the old table
as possible (eg. videofilters, contrast, brightness, ...)?
--
Gregorio Gervasio, Jr.
More information about the mythtv-users
mailing list