I know this has been posted often, so please forgive yet another post on this subject. I have a blog hosted at Yahoo, but am moving it to A Small Orange where I have a couple of other sites I am setting up. The site will be set up there as an add-on domain.
I followed the instructions from Podz' site. Backed up my database, copied all the blog files into the appropriate folder. Created a new database there and imported the database into that (using phpmyadmin). The database name is different from what I can gather. It was 'blog' at Yahoo and XYZ_blog at ASO. I changed that in wp-config.php.
However when I log into abcd.net/XYZ/ where XYZ is the folder in which I put all my blog files I get the dreaded message
"This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at mysql. This could mean your host's database server is down."
Any help would be much appreciated. I will be pointing my DNS servers to the new site when it is up and running.