Page 1 of 1
Multiple sites on 1 DB
Posted: Fri Oct 15, 2004 8:17 am
by sanjay
Hi, I'm new to this CMS, but have to say it's great for small sites that do not require user submissions.
I think it's possible to have multiple sites on 1 database, could someone point me to the instructions on how to do this?
Has anyone shared the DB with another CMS, like phpws or Mambo?
Thanks
Sanjay
Multiple sites on 1 DB
Posted: Fri Oct 15, 2004 9:32 am
by Ted
Sure, you can share multiple sites easily on DB easily. When you install CMS, change the database prefix on page 2 of the install from "cms_" to anything else (say "othersite_"). This will make all of the tables from the new install all have that prefix in front of their names, and should not conflict with anything else that is in there.
Re: Multiple sites on 1 DB
Posted: Tue Jun 30, 2009 11:38 am
by spiriralph
But how can share one Database (tables) for 2 or more web sites (hosts) creat alians web site not use iframe

?
Re: Multiple sites on 1 DB
Posted: Tue Jun 30, 2009 11:53 am
by alby
spiriralph wrote:
But how can share one Database (tables) for 2 or more web sites (hosts) creat alians web site not use iframe

?
In step 5 of install you can select a different prefix for tables (default is cms_) then you have another site installation with own DB tables
Alby
Re: Multiple sites on 1 DB
Posted: Tue Jun 30, 2009 2:02 pm
by spiriralph
ONE Db for many web site alliance!
not copy of tables in mySql for sub domains or sub dir!
equal content for _http://ZZZ.COM & _http://YYY.com & _http://TTT.com & so on ....
Re: Multiple sites on 1 DB
Posted: Tue Jun 30, 2009 2:30 pm
by Nullig
If you want them to have the same base data, then just use the same db and tables - you can edit the config.php file to point to the same db.
You could work this very well, using a menu structure like:
1 - Site 1
1.1 - Site 1 Home
1.2 - Site 1 Products
1.2.1 - Site 1 Widgets
1.2.2 - Site 1 Things
2 - Site 2
2.1 - Site 2 Home
2.2 - Site 2 Services
2.2.1 - Site 2 Tech
2.2.2 - Site 2 Office
3 - Site 3
3.1 - Site 3 Home
3.2 - Site 3 Rentals
3.2.1 - Site 3 Homes
3.2.2 - Site 3 Condos
Each site would have it's own menu and you could use different templates/stylesheets to make them look different. It would be an interesting experiment to try.
NOTE: if they're on different hosting servers, you will have to change the:
$config['db_hostname'] = 'localhost';
to the proper remote hostname for the db.
VERY IMPORTANT!!!! The sites must all use the same CMSMS core file and module versions, as this is maintained in the db. If any site uses any additional modules, or different versions of modules, it will probably bugger the others.
Nullig
Re: Multiple sites on 1 DB
Posted: Thu Jul 02, 2009 11:58 am
by Pierre M.
spiriralph wrote:
equal content for _http://ZZZ.COM & _http://YYY.com & _http://TTT.com & so on ....
This duplicate content scheme is best achieved at the webserver level (virtualhosting). It is not CMSms specific.
Pierre M.