Quoted from cPanel, "As many copies as you like, one database."
What can this feature be used for, or what does this mean?
- multiple, duplicate live copies / sites?
You can have multiple installs of MyBB on one database. They are not connected in anyway, e.g. user tables, etc. You can have several copies on on DB if, for example, your host limits you to four DBs.
Make sure the tables have a different prefix though, or you'll have SERIOUS problems.
(2011-11-15, 11:47 PM)fizz Wrote: [ -> ]Make sure the tables have a different prefix though, or you'll have SERIOUS problems.
This... And you can have as many tables in one DB, as long as they have a different prefix.
OK, thanks.
Follow up questions.
Is there reason one would be faster than the other - 2 forums on the same database -vs- 2 forums on 2 databases (same shared account and server)?
different databases is better, plus it is more secure.
Using multiple is better and more secure, as pavemen said. Just because it can do something doesn't mean you should do it
If you're using the same username and password to access both the databases, then it's NOT more secure to use two different databases...
The general settings like "max_user_connections".... apply to ALL the connections to MySQL and not only to a specific database...
Both the databases are on the same server so there isn't a physical seperation between them, it's just the database name, username and password that changes... SQL = files stored somewhere
of course its not any more secure if you use the same credentials, that would be the point of using two separate DBs, to run then under different credentials to improve security (as long as config.php is not compromised)
plus two different DBs is easier for bookkeeping of backups, maintenance, restores, etc. can't screw up two sites in phpMyAdmin from one bad command.
yes, each table in a database has its own 3 files on the file system, but at least they would be different folders if in different DBs