MySQL Forums
Forum List  »  Newbie

Merge tables with another database
Posted by: mogens lunde
Date: February 28, 2011 04:51AM

I need to merge two websites, which I intend to do by making a dump/export of for example table_customers in DB1 into table_customers in DB2. However, I need to add a number to each field customer_id so that they start where the other tables numbering ends.

But how do I make a dump and at the same time specifying to add a fixed number to customers_id (have access to PHPMyAdmin)?

My database has md5 passwords that I hope can be used when old customers from DB1 log in into DB2. Could I expect this to work "out of the box"?

Thanks for any help!

Options: ReplyQuote


Subject
Written By
Posted
Merge tables with another database
February 28, 2011 04:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.