I'm trying to replace the wordpress database I have on my live server. Here's the scenario: I have two databases on my server. The old one and the new one. When I edit config.php to change the database name from the old one to the new one, WordPress wants me to re-install.
Here's why I'm confused...
- The tables in the new database have been updated to the old URL (I'm keeping the same URL).
- It's the same database user so the db user and db password don't need to change.
- The db user has permissions for the new database.
I thought that I should be able to change the database name and go, but WordPress isn't letting me. Any help would be greatly appreciated. I've been working on this for serveral hours and I'm at my wit's end. I know there just HAS to be a way that doesn't involve manually adding/editing content in the WordPress admin. Thanks in advance.