MySQL Forums
Forum List  »  Data Recovery

Importing/Restoring Multiple mysqldumps to One Database
Posted by: Travis Mount
Date: October 01, 2009 12:20PM

I am curious as to if there is a way to restore multiple dump.sql files into a single database, appending the data to what is already in the database?

For example, say I had a database dump for three separate companies (which all contain the same fields), and I wanted to make a single database with the data from all three companies. What would be the best way for me to go about this?

If my example isn't clear, just ask - I am kind of new to this, and unfamiliar with some of the terminology. Thank you!

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing/Restoring Multiple mysqldumps to One Database
4489
October 01, 2009 12:20PM


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.