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