Forums

Sub-Domain using existing database for C5 on primary domain

Permalink 1 user found helpful
Is there any documentation for installing C5 on sub-domains and sharing a single database with primary domain? When attempting to auto-install C5 on the sub-domain, error message "Conflicting Database Tables Exist" is returned and I am unable to complete the install. Suggestions? Any known issues or reasons why I shouldn't go down this path?
jagdecht
 
Mainio replied on at Permalink Best Answer Reply
Mainio
What of these are you trying to do:
1. Use the same c5 instance for all the sub-domains, so all sub-domains are under the same c5 installation?
OR
2. Use the same database for multiple c5 installs?

The first one is possible through some add-ons (we also have one that hasn't yet been published) and the second one is not possible because there's no support for database table prefixes in c5. Therefore, you must have a separate database for each c5 installation, which I don't personally see as a bad thing at all (because c5 is such a db table monster).

Antti / Mainio
jagdecht replied on at Permalink Reply
jagdecht
I was attempting to use same database for multiple C5 installs (#2). It seems others have done this successfully based on other forum posts. However, I decided just to install using a new database. Thanks for the reply.
Mainio replied on at Permalink Reply
Mainio
Yeah, "everything is possible" when talking about OSS but it's just matter of what you should do and what not. There are multiple reasons why the same database shouldn't be used for multiple installs.

I'm glad you went with installing an own database for each instance of c5.

The only way to get multiple C5s working from the same database would be database prefixes which is natively not supported by C5 currently. Of course, you can do that if you override or hack many files in the core.

I also found this topic where someone has made a core-hack script for this purpose:
http://www.concrete5.org/community/forums/customizing_c5/database-p...

However, that should not be used for anything else than experimenting because it still does not seem to work perfectly and also does not add support for table-prefixing the add-ons.


Antti