Adding db to subdomain - how to?


#1

hi, i’ve just gone ahead and done it, but more curious than patient and this might save some people some time as i don’t see any discussion of it.

i have a subdomain: example.domain.com
and i want to add a db to that subdomain,

so i select example.domain.com as the domain to add the db to and then enter the db as:
mysql.example.domain.com

and then add the user, pw, etc.

will this work just fine?


#2

Yes it works fine. I’ve just changed my site to get rid of some of the folders in domain.com to subdomain.domain.com. Moved my databases to the subdomain and it was fine. If you change your database location, the old link mysql.domain.com will still work for a few days until your have updated your scripts. The new link should work after a few mins (if your subdomain has been working for a while (DNS to propagate)).


#3

tehcnially, you don’t need the db.subdomain.mydomain.com
YOu can just access it as “billie.menchit.dreamhost.com” or whatever your server is…

What I did was ping db.otherdomain.com I had setup, and then ran “dig -i x.x.x.x” (where x.x.x.x is the ip number).