I got fed up with our 1and1 shared hosting account and just provisioned our new dedicated server.
I read this post about how to migrate WordPress with zero downtime which recommends replicating the database and editing the config file, then just fliping the switch on the data once the DNS has propogated. But I'm stuck at square one...
What might keep my WP install from connecting to my new dedicated server?
I have created and imported the database and user with full access on our new box. I edited my wp_config and confirmed all the correct details including new host name. I enabled the cPanel option to allow Remote MySQL access to the new server.
As I mentioned, my site and forums currently reside on a 1and1 shared hosting account. The old/current database resides on some 1and1 server at mydb.perfora.net (not localhost), so I should easily be able to run from mynewdb.mynewbox.net ... alas, I only get "Error Establishing Database Connection".
One suggestion was that 1and1 may blocking the connection from that end. All ideas welcome. Thanks!