Posted 4 years ago #
I got a new host, so I need my blog on a new server.
I followed the instructions here:
http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_to_a_New_Server
and restored using Fantastico.
Now I get this error:
"Error establishing a database connection"
What other info should I share? Where do I begin? AFAIK I just did a backup, installed WP on the new server, DROPped the default database and imported the backed up sql file.
Did you update your wp-config.php file? When I switched hosts, I had to have them help me with the new database settings since they did things a bit differently than my old host.
Posted 4 years ago #
aaah, no I didn't. It will be the same URL, but I was hoping to get it working with the IP address in the browser URL bar first.
I guess I could switch Nameservers and use an IP for the old host...
Is there a way to check it without doing that? Is that definitely a URL issue do you think?
For your wp-config.php, you need to change:
The name of the database
Your MySQL username
Your MySQL user password
To those of your newly created MySQL database on your new host.
Although I was able to install it, I wasn't able to get WordPress working until the DNS propagated and I could access it by domain name instead of IP. I left my old site up until this was completed.
Posted 4 years ago #
Isn't the password encrypted? How can I record that in the wp-config.php?
no, the password in wp-config.php isn't encrypted. This is quite normal, as that file can't be opened in a browser.
it's executed by the server, so the contents of that file never leave the box, unless the server is grossly misconfigured.
Posted 4 years ago #
Ok, i just re-installed everything, and I think the problem was the coding. The blog should have been Latin1, whereas before I imported it as UTF8. Weird.
Thanks for the hlep iridiax. Editing wp-config.php sure was part of the problem. I had to make sure the two databse filenames were the same.
Cheers.
This topic has been closed to new replies.
