I just moved my WP site from an old host to a new one and I'm issues with my database.
After uploading my .sql file to my new database server, I go to log into the my dashboard and I get a message saying:
Error establishing a database connection
In the address bar, it keeps pointing to my old database (which is gone now).
I've read the documentation on how to move to a new server, but the reason I initially moved was because I could no longer access my WP Dashboard on my old server. I figured moving would simple (I've had to do it before.)
Unfortunately, if I try to use the .sql file from my old database, I can't access the dashboard and keep getting the error message.
Deleting the tables and reinstalling the database on the new host allows me to access the dashboard, unfortunately, all my posts and comments are gone. (Because I can't import the old .sql file without causing problems.)
Is there any way to fix this, or am I doomed to just have to start reblogging from the beginning. (Not something I'm willing to do.)