Install Multiple copies in the root

[bsdotnet]

What i need to do is set up three folders under my domain and install 4 seperate installs one in the root and one in each sub folder, I need a cms on the home pages and a seperate install in each sub folder as below the root installation works but when i attempt to install into the folders below the install jumps from the system check page directly to the thanks for installing page.  Is it even possible to have the cmsmade simple in the root of your domain then install again in sub folders from the root.

/club1
/club2
/club3

Cheers.

[robsta]

yup easy as

just install into the 3 sub directories plus root

use the installer to set each cms up... but give each install a separate database prefix... and your away...

I've got 20 running under the same hosting plan in separate directoris with only one database... but HEAPS of tables

Robsta

[robsta]

Okay reread this again

Try quitting out of your browser before installing in another directory.. it's probably using the previous session...  to check whether you've installed..

[duplay]

Can anyone help me with the above in more detail? I would also like to install cms under my root site so it would be www.mysite.com/subsite1, is this possible?


When you say use prefix- do you mean when I am installing the subsite1, point it to the main site DB? or create a new DB with a prefix?

Thanks

Windows server for site
OSX for DB

[KO]

With prefix robsta means table name prefix. So you have one Database that different CMS installs use but those different CMS installs have their own table name prefix. So table names comes

cms_module_news    - on first CMS installation
cms_anothercms_module_news  - second CMS installation.

Ofcourse you could have separate databases for each installation or having single database sharing same database with forum, ecommerce or something else.

[duplay]

Makes more sense, but here is another question.

If I have my main site www.site1.com pointing to a single DB called "site1" and I want to create a www.site1.com/subsite1, do i run the install and point to site1's db and just add a prefix? (wont that over-write anything that is in the root site db)


Also, if site one is in a folder called "site1" Do I place the subsite folder within site1 with another full version of CMS?


Thanks

MJD

[KO]

If I have my main site www.site1.com pointing to a single DB called "site1" and I want to create a www.site1.com/subsite1, do i run the install and point to site1's db and just add a prefix? (wont that over-write anything that is in the root site db)

Also, if site one is in a folder called "site1" Do I place the subsite folder within site1 with another full version of CMS?

- You point to site1 Db and have different prefix for table names for www.site1.com/subsite1 than you have for www.site1.com. By default CMS uses cms_ as table prefix and you change prefix during installation. and...remember, Backup before you do anything.

- You have to install another full copy of CMS.

[Pierre M.]

Hi all,

feel free to upgrade the wiki about this :
http://wiki.cmsmadesimple.org/index.php ... d_database
database sharing, multiple sites, subfolders...

Pierre M.

[robsta]

Sorry got caught in a mindflux yes one database with multiple tables prefixed for each site

... it works.

[duplay]

OK I got it and it worked, but here is my next question:

If I have three separate sites with three separate databases, can I merge them into one DB with different prefixes?

(ex. Keep site 1 and DB1 and insert site2 and 3 in the site 1 folder, then merge db2 and db3 into db1 with prefixes? If so, how?

I am using MYSQL with MYSQL Administrator, but dont see anything for merges or backups. Thanks

[robsta]

as long as your sites can each see the master database there shouldn't be a problem...

But if they're already separate databases and on different servers I'd probably leave it as is that way if one site goes down the others will still run...