> >> 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)
> > information in those 12 tables to an identical functioning system (same
> > software, same db, but other server) and I need to preserve the
> > 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
> Then start inserting.
> After that add the auto increment attribut again.
> use bulkcopy(?) if im not mistaken, or any other methods to copy as it is
> new dbservers
> (compress it first).
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.