Multisite: Three sites, one database

Events happening in the community are now at Drupal community events on www.drupal.org.
DrupalNovice's picture
Posted by DrupalNovice on January 27, 2009 at 10:14pm

Hi!

Due to hosting costs, I'd like to try having all of my clients three sites fitted in on database. How would I do this?
1. Through prefixing the tables?
Can I specify which tables belongs to which sites in one single database? I'd like to share the user and roles tables though.
Is this the way to achieve it?

Any insights on this would be appreciated! I'm a multisite first-timer, so I'm a bit lost in the worklflow for this..

Thanks!
DrupalNovice

Categories:

Comments

Solved

Posted by DrupalNovice on January 28, 2009 at 7:39am
DrupalNovice's picture

Solved, sorry for posting such a stupid question. =P

Regards,
DrupalNovice

how did you solve this

Posted by haojiang on February 27, 2009 at 4:27am
haojiang's picture

how did you solve this problem , table prefix?
could you paste it out here
i am using "project/domain" and having some table prefix problems

prefix only way TO solve this

Posted by btopro on February 27, 2009 at 2:24pm
btopro's picture

site1_
site2_
site3_ is the only way to solve this, you can centralize several sites though to save DB space and what not.

"Plaguing the world with Drupal; One Plone, Moodle, Wordpress, Joomla user at a time since 2005." ~ btopro

http://elearning.psu.edu/
http://elearning.psu.edu/projects/
http://elearning.psu.edu/drupalineducation/

Ex Uno Plures
http://elmsln.org/
http://btopro.com/
http://drupal.psu.edu/

Multisite

Group organizers

Group notifications

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