2

Well Hello,

I've the need to merge 2 different databases together. But! I need to keep some data from 1 and other data from the other one...

DB 1: is a multisite setup 
DB 2: is only 1 website... 

DB 1: has all the setups for the other sites plus it works with new layout 
and has some dummy products... 
DB 2: it's the db of the current life site.. but I only need the products,
users & their data and newsletters mails

-

So my question is, do you guys know a way I could merge the 2 databases and have them working?!

  • 1
    You're probably best off exporting and importing instead of merging databases. – Rick Kuipers Jun 27 '13 at 13:32
3

There is not an easy way per-se to simply merge the data in the two databases, it's simply not the nature of MySql, and the large relational schemas which Magento uses means it wouldn't be as simple as copying data from certain tables into the other database.

The best (and really the only) option you have will be to export your data and then use the same tool to import the data into the other website setup.

My tooling suggestion would be to use uRapidFlow Pro for product information and the built-in Dataflow Profiles for handling customers.

|improve this answer|||||
  • 1
    I would upvote RapidFlow 5 times if possible. Unirgy makes some incredible products. I think RapidFlow even handles order import. – philwinkle Jun 27 '13 at 14:18
  • so you suggesting me to export/import? I read this other question here that is kinda similar... they said it's better doing it with databases. – Smith Jones Jun 27 '13 at 14:56
  • Yes, export/import is what I'm suggesting. In the case of the question you linked to, the poster was upgrading a single Magento installation to a newer version vs your case where you want to combine two instances of Magento into one. – davidalger Jun 27 '13 at 15:05
1

Another option is cart2cart, but the cost depends on what you want to move and how many records you have. In my experience, I've found it much more time consuming to move product and customers than to change setting to support your theme, but that's just me. Since db1 has more stores, if your going to keep them, just import the db2 over to replace/overwrite that data in that one store. You can overwrite single tables; you don't have to move the whole database. At the end of the day, pay somebody to do this or buy a service. If it's you're first time, this process will really make you hate Magento.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.