It sounds like you should be doing the link preservation and number
update part in php or perl.
Neculai Macarie wrote:
>>>>Not that I'm aware of. What type of conversions are you doing that you
>>>>need 30,000 use vars? An easy solution would be to try it and find out
>>>>
>>>>
>:)
>
>
>>>I need to move multiple linked entries (in around 12 tables) from one
>>>running server to another. I'm using auto_increment's all over the place
>>>and
>>>I have the following problem: I need to move (no replication possible)
>>>
>>>
>the
>
>
>>>information in those 12 tables to an identical functioning system (same
>>>software, same db, but other server) and I need to preserve the
>>>
>>>
>relations
>
>
>>>between the tables. The problem that I have is that the systems evolve
>>>independently and I can have the same id for 2 different entries on the
>>>system (e.g. on the first system I can have the id 10 for User1, but on
>>>second system id 10 would be for another user).
>>>
>>>
>>>
>>Perhaps after you dump the structure and data into sql files,
>>you could remove temporarily the extra attribut auto increment to those
>>columns.
>>Then start inserting.
>>After that add the auto increment attribut again.
>>OR
>>use bulkcopy(?) if im not mistaken, or any other methods to copy as it is
>>
>>
>to
>
>
>>new dbservers
>>(compress it first).
>>
>>
>
>Donny,
>
>Thanks for the answer. Dumping the structure and data alone (mysqldump
>style) is not helping me because the tables are linked and I must update the
>linked tables with the new id's.
>
>
>
