MySQL Forums
Forum List  »  Backup

Re: Merging two database together
Posted by: Rick James
Date: May 09, 2011 07:32AM

AssetID -- are there duplicate values between the two sources? If so, you will have to write a program to deal with it.

MyISAM ignores FOREIGN KEY CONSTRAINTs; you have no explicit constraints anyway.

I have never heard of SQLDUMP; can you explain how it works? Does it produce INSERT statements, like mysqldump does? Or does it work some other way?

In the best of worlds, your dump is a collection of INSERT statements, and none of the values of AssetID are the same between the two sources. Then simply feeding the dump to mysql will work fine. Otherwise, it could be problematic.

Options: ReplyQuote


Subject
Views
Written By
Posted
4203
May 07, 2011 11:46PM
Re: Merging two database together
2966
May 09, 2011 07:32AM


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.