I have wordpress running fine but I wanted to change the database name that it is using.
I changed wp-config.php and I copied everything over to the new database and admin works perfectly.
When I go to the blog the posts show up but the links, comments, and archives all say they can't connect to the old database name:
Table 'bnbfinder_usa.blog_links' doesn't exist]
The table name should be bnbfinder_blog not bnbfinder_usa.
bnbfinder_usa was the old name.
It seems still have the old database name in memory but I don't undestand how that could be if part of the page is loading and it's using the same db class.