Posted by: manjo
Posted on: 2006-11-13 19:01:00
When I try to create a database, the interface asks me for hostname: mysql.website.com why is that? Does that mean that if I point my browser to mysql.website.com it will take me to phpmyadmin etc ? I have used Cpanel before and I did not have to enter a subdomain to create a database so I am confused.
Thanks a ton.
Posted by: rlparker
Posted on: 2006-11-13 19:07:00
In reply to:When I try to create a database, the interface asks me for hostname: mysql.website.com why is that?
It asks that so that the Dreamhost system can build a subdomain for referencing the phpMyAdmin interface and for use in other places (such as in scripts) where a hostname is required.
In reply to:Does that mean that if I point my browser to mysql.website.com it will take me to phpmyadmin etc ?
Yep. You can name it "anythingyouwant.yourdomain.tld", the "mysql.yourdomain.tld" is just a suggestion. 
The Dreamhost Control panel works differently than cPanel; once you get used to how much more powerful and flexible it is, you will never be satisfied with cPanel again!
--rlparker
Posted by: wholly
Posted on: 2006-11-13 19:10:00
Word.
The trick here is to realize that you're not just creating a "database" but you are actually defining an entire server. Just recently they managed to get one-click installs to share a db server. (I know this because I have four apps and four different physical DB servers. I really should see about merging them)
WhollyEdited by wholly on 11/13/06 07:12 PM (server time).
Posted by: manjo
Posted on: 2006-11-13 19:23:00
ok got it! Does that mean when I install gallery2.0 or webcalender etc I could use mysql.mydomain.com, ie the same "mysql subdomain server" name for any databases I create ?
Posted by: wholly
Posted on: 2006-11-13 19:29:00
Yep, Just check that the app uses a "prefix" to ensure you have no table name crashes.
There are also times where separating the data would be a good thing (unrelated sites or so on). Keep that in mind!
Wholly
Posted by: bjornl
Posted on: 2006-11-14 05:05:00
Yes. Since DreamHost does not run their MySQL servers and Apache servers on the same machines, you can't use only localhost as hostname.
Posted by: aunliner
Posted on: 2006-12-02 21:10:00
I've restored my mysql file from my old host and imported them through phpmyadmin. I've copied my gallery's files in my folder, however I know I'm missing a step before the gallery and database click together. What do I do to get my gallery functioning at this point?