Information Centre

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. In some situations, it can make database administration a great deal easier.

Here's an example of where you may choose to use such a configuration.

You may have two scripts on your website, 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 or have multiple scripts writing to the same table. 

If this approach seems a little too complex, rest assured in the knowledge your website hosting account offers unlimited database support.