SQL organization questions


#1

I hunted around and searched for answers & haven’t found them yet. Still looking though. Maybe my searching and sql skills are both weak :slight_smile:

Is it ok to …

… use the same database name for more than one application?
… put separate databases for multiple applications on the same hostname?
… is the “mysql.” needed in mysql.domain.com? (Same question better wording I hope) Can I just tell it to put the database(s) in domain.com

And finally is it possible to move a database to a different hostname? If so how.

Thanks
Dan


#2

my opnion is no. You should have different databases for different applications.

Benefits: admins who are able to delete records will not mess up the data for other applications.

mysql.domain.com is the MySQL hostname. We should not put databases in domain.com because visitors are able to review the files.

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].


#3

Thanks, now it makes a lot more sense.

Dan


#4

you are welcome!

I’m glad I can help a bit.

Save [color=#CC0000]$97[/color] (max discount) on dreamhost plans by using promo code: [color=#CC0000]97CRAZY[/color].