|
|
Posted by Piotr K on 12/16/05 11:24
Piotr wrote:
>> You can't. You need to dump the local table, drop the remote table,
>> and recreate it with the dump of the local table.
>
>
> Iou don't understood me. I can't drop remote table because I have
> important data there. I want to change structure only!
Hi, what if you dump data on remote host with full insert information
(with column names). After drop table and recreate with new structure
you can execute those inserts on new tables and put data back to tables.
Of course this solution will work only if you add columns to table, in
case of column removal or rename it won't work.
greets
piotr
Navigation:
[Reply to this message]
|