Multiple copies

[thomascanty]

I'm going to be installing EE pretty soon, but before I get to that, I was wondering if it would be possible to install more than one copy on a single server. I would think it should be fine, but wanted to ask for clarification before I try it.

[DavidW]

The only issue I can forsee is that each EE installation needs its own MySQL database. I don't believe there's any way to configure different EEs to use different prefixes for table names in the same database.

This is only an issue if your hosting provider only allows you a limited number of MySQL databases. You can often use the same database for EE and other dynamic web packages (as all EE tables are prefixed with ee_) - it's just that you can't have several EEs using the same database.



David

[thomascanty]

I can have up to 50 MySQL databases, so that isn't a problem. As long as each instance of EE can be set to use it's own database, I guess it should work fine. My concern was whether the database name was hard coded to the point they would all be pointing to the same place.

[DavidW]

You configure the details of the database in basecode/SETUP_settings.php (it's fairly clearly marked near the top of the file). You should also configure the details in <management folder>/backup/ee_backup_prefs/preferences.php

At least for now, the table names are hard coded (it would be nice if there was an option to configure the prefix used for the table names), but the MySQL server, database name, user name and password are all easily configured.



David