Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By MrMattles on
Hello Hello Fellow Drupalers,
Due to many a health reason, I have been largely away from the industry and Drupal for the last 12-18 months...but I am back and for those that do know me Im biting of fmore than I can chew, in typical me style....
Anyways From my bit of a play Im am impressed where things are at the moment as far Drupals progress...all I can say is WOW....
Back on topic however Im in need of some very basic assistance to kick start a project Im workin on, I am working on a MultiSite Project and, basically the big issue is I want to share content and users but not site settings (ie Slogan, Mission, Theme Settings, Blocks etc) I have tried prefixing the variable and system tables to no avail....would anyone have any suggestions to get me kick started?
Thanks for the help,
Im planning on porting and developing a few themes in the coming months and also contributing some documentation now that things are starting to get back on track for me.....great to be in contact again....
Matt
Comments
I should point out
I should point out of the reason I ask this is because I have tried some basic settups like sharing the variables and settings tables and cache tables but the sites always seem to end up sharing their slogan/missions at the moment the minute a theme setting on one site is changed. and I know their individual settings.php files are been read because that is where their site names and themes are currently defined and used.
Thanks,
Matt
Been away from drupal for 6 months, health and other reasons.
Worked on some very cool drupal projects and I am starting some more currently.....looking forward to a drupalised future.
settings.php?
In the settings.php of Drupal 5.1 there is a possibility to share database tables in multisite configuration.
Doka
Doka
Ahh yes but.....
Yeah I have seen that and for the most part yes I want to share the database with exception to what ever table controls the "site variables" should this be only the variables table that i need to prefix or should I be prefixing the system tables blocks etc aswell???
Been away from drupal for 6 months, health and other reasons.
Worked on some very cool drupal projects and I am starting some more currently.....looking forward to a drupalised future.
Yes
The site slogan, etc. should only exist in the "variables" table. The "system" table controls which modules are enabled, so it may not be a good one to share unless you want the same modules on all sites. Likewise, the "blocks" table (and "boxes" table) controls which modules are enabled and where they go, so you might not want to share that either.
Let's see, the following might cause you difficulties as well: node_access, menu, cache*, permission, role, url_alias, ... and maybe others. I think I'd go with the standard suggestion: separate databases.
Nancy W.
Drupal Cookbook (for New Drupallers)
Adding Hidden Design or How To notes in your database
NancyDru