ALURIAN

Dimitrijs faced several problems when transferring some sites to his customers’ Dreamhost account.

You know I have already successfully transferred more than 100 Prismotube sites and have some experience in it. But the last transfer makes me crazy.

I suggested my buyer to purchase an account at Dreamhost which, now I know, doesn’t have a cPanel. It took time to figure out how to setup everything and transfer the database and files, but I stuck with the db_config.php error: “Could not connect to database. Please check your DB Settings from your admin area or in “config/db_config.php”"
I know it happens when the database name, user or password isn’t correct. I checked it many times, but nothing helped.

You suggested Dreamhost as a powerful hosting for Prosmotube. I bet you tried it yourself and can help in this situation.

I’m still confuse what to use as the database username and password and how it should look like on the Dreamhost.

He found out that the problem was that Dreamhost doesn’t use ‘localhost’ as the MySQL host like most webhosts do.

The problem was in the host name. In most cases we tend to use
“localhost”, but it doesn’t work for Dreamhost. The host name for a
Dreamhost hosted database is *mysql.domain.tld* (the “mysql” part may be
changed during the database creation)

One more disadvantage of the Dreamhost is their phpMyAdmin. You don’t
have access to phpMyAdmin until the name servers are pointed to
Dreamhost and updated.

The soution to the phpmyadmin is to create a temporary web URL and to either manually install a temprary web URL or to use the inbuilt database manager.
We really didn’t document the inbuilt database manager although it is very powerful because it can be destructive in the wrong hands and can potentially cause tech support nightmare for us.
So please, only use it if you absolutely know what you are doing!!!!!

I’ll let you in on a little undocumented feature of Prismotube.
Prismotube has it’s own mini phpMyAdmin.
Just login as admin and go to www.[THEURL].com/admin/phpminiadmin/index.php
And you can install phpMyAdmin manually on the server manually too.
Check this out: http://wiki.dreamhost.com/index.php/DNS_-_Viewing_site_before_DNS_change
You can use a temp subdomain while waiting for the domain nameserver to propagate.

Read more on :

http://wiki.dreamhost.com/index.php/DNS_-_Viewing_site_before_DNS_change