Best way to import/Export or Merge two drupal sites?

czarphanguye - June 15, 2007 - 13:13

So I have a Drupal forum archive with say 1,000 topics sitting on Drupal v4.7.x and now run a different Drupal v5.x forum. How might you go about merging the two database and/or export the forums and import into v5.x? The Import/Export module looks to export everything into CVS, yet the original node_ids remain which will over-write if imported to the other.

Edit post disabled?

czarphanguye - June 15, 2007 - 13:15

Edit post disabled? anyways, http://drupal.org/project/importexportapi is the import/export module that looks alright.. yet I'm look for ideas.

..

Phillip Mc - July 8, 2007 - 12:35

Hi czar,

I'm trying to do something very similar. I tried using the import/export api but it wouldn't work for exporting and importing the forums and posts.

Did you find a workaround?

Phil

"Did you find a

czarphanguye - July 9, 2007 - 10:01

"Did you find a workaround?"

I've not found a way yet to import my content without overwriting and or conflicting nid/tid entries. As you see, your the first to reply to this request, yet your bump is welcomed as I find it amazing only you and I are trying to merge databases like this. ;-x

I did manage to import most of the users, yet the forums and blogs remain a mystery.

Regards,

Czar

Hands up

westsyde - October 6, 2009 - 01:55

I'm in the same boat, so your not alone..

As a newbie to mySQL driven sites such as Drupal I am doing a lot of head scratching with merging production site content back into the development site so I can release the changes make in the development site without loosing anything from the production site.

The project found at http://drupal.org/project/dbscripts leads me to believe that options available are not for the faint hearted.
The blog for this package can be found here http://ceardach.com/blog/2008/06/development-production-database-merge-s...

Have a look and give it a go if you are familiar with shell.

Double D Works Ltd
DoubleDworks.co.nz

 
 

Drupal is a registered trademark of Dries Buytaert.