Moving Sites built on MultiSite to work with Domain Access

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
dotman's picture

Hi,

we're in the process of moving our main site to Drupal and was intending on using multisite. We've already move one smaller site over doing just that, and will be moving another over soon.

Now our manager really likes the idea of sharing content across all sites, which I was guessing would mean using the Domain Module.

How hard is it, or more specifically, what would be the process of moving sites that each have their own database to use Domain Access, since what i understand is, it uses one database for all sites.

Has anyone done this in mid stream so to speak, and how practical or difficult is it? is their another method of sharing content between sites that we should consider given where we are at now?

Really appreciate any advice anyone might have.

Thanks,
Doug

Comments

It would be excessively

Garrett Albright's picture

It would be excessively difficult. You won't be able to just "merge" the node tables for each site together very cleanly, since they will have their own unique node IDs that overlap - that is, node 10 on each site will be different. It's not that big a deal if you're okay with just letting the node table reindex itself, but then that messes up every table which joins to it - all the CCK/field data tables, for instance.

Your best bet will be to somehow export the content of each subsite in some non-SQL manner and then re-import them into the DA master site in such a way that all the fields and other data hold together. Oh, do each of the subsites have their own content types, with different fields on each? Oh, man, this is gonna hurt.

So yeah, this isn't impossible, but it's not going to be a whole lot of fun either. If it's not that much content to start with, it may be faster to just do copy-paste jobs instead of trying to automate the import.

Good luck, friend.

Detroit

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: