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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
