MySql question

[gladi8tor]

I am using Hostgator w/Cpanel. New to this website design stuff. Here goes: Each time I create a new domain site, do I have to make a new MYSQL database?

I was going to create some YACG sites, and I was wondering if I need to create a new MySql and upload program there?

 

[pig2cat]

You can use multiple things on one database as long as the names don't conflict with eachother(you can't have 2 tables named 'users' for example).
so for each site i suggest you just make a new database, it's easier to keep them apart too

 

[Jondoe0069]

A good way of doing it is beginning everything from each site with:

SiteA_Users
SiteA_Billing

SiteB_Users

etc. etc.

If you want to use one DB, this is the way to keep it organized.

 

[gladi8tor]

Ok, I think what I am going to do is create another database for his project.

 

[rdmillerjr]

I would suggest that instead of creating a bunch of databases or attempting to come up with some naming convention to allow you to create a bunch of tables within the same database, I would just use one database and create relationships on the data. For example, create a table called sites, then when you create the tables, users and billing just add an additional field called site_id to tie the proper records to the proper site.