|
While you're able to create as many MySQL databases as you wish with your
Domain Registration Services web
hosting account at no extra cost, you're also able to use a single
database for multiple applications.
The advantages of using a single database in such a way is to eliminate
multiple database logins and connections.
Here's an example.
You may have two scripts, a poll and a guest book, each requiring a MySQL
database. You could create
a database called "poll" with "questions" and
"answers" tables in it, and another database called "guestbook"
with a table called "guests". Each table would have the appropriate
fields for its scripts to operate.
If you wish to consolidate the two databases into one, simply do the
following.
Create a database called (for example) "master and in it create tables
called "poll_questions", "poll_answers" and "guestbook_guests".
When you configure your scripts, give them these names for the tables and each
script will be able to use the same database for its operations. They will each
call the "master" database and use the same login/password.
Note: be sure to give each table a prefix specific to the application
you are going to use it for, so you don't accidentally specify the wrong table
in your script configuration.
|