Posted by prathamesh.save on February 8, 2013 at 1:49pm
I setup 4 multisite at same level means they only share users table all other
remaining tables are not shared.
Used single database for all four sites, differentiate using different
prefixes and code base is also same.
Example:-
Site Name: site1.example.com
Site DB Default Prefix: 'site1_'
Site Name: site2.example.com
Site DB Default Prefix: 'site2_'
Site Name: site3.example.com
Site DB Default Prefix: 'site3_'
Site Name: site4.example.com
Site DB Default Prefix: 'site4_'
I Want to get all my node data using 'views' from different sites ( my
multisites ) for particular content type e.g.(article)
How can i do this??
my node tables are not shared:
prefixes like site1_nodes, site2_nodes, site3_nodes, site4_nodes.
Thanks,
Prathamesh
Comments
Sharing content in a multisite environment
I don't think you can do that without writing custom code specific to your installation. Otherwise your "site1" won't ever know to look in the "site2" database; you need to put the data you want to share between sites in the "shared" database, although it's not always clear-cut which tables to share. I find the "anywhereindb.php" script very helpful in figuring out database issues like this.
You might be better off sharing nodes, views and other appropriate tables between sites if that's what you need to do. If you do that, remember to share "field_" tables too. I move them into the "shared" database as soon as I create them, before they have much content. Do that as you set up new content types and fields, or you'll end up chasing down a lot of problems. Also, if you do this, don't forget to clear all caches every time. You might need to run the update script and/or cron to get rid of PDO and other errors.
For one theme development project on my dev server, I have 6 sites, with a "base" site that I use to point some items to, and 5 other sites that as of this writing share 91 tables. Each individual site database has less than 70 tables. When I do something like this again, I'll set my default db in settings.php to my shared database instead of the opposite, which I did when I set it up originally according to the instructions found in http://groups.drupal.org/node/170929.
Of course, if this is a production environment, and you can't really share access to content between sites, I think you're stuck doing a lot of copying and pasting.