I have followed the instructions in the Codex for moving WordPress from one server to another, but I'm still having issues with it.
When I go to a URL that I know exists on the site (yes, I refreshed my permalinks), it throws the 404 page. If I go into the admin and try to view the list of posts, this is what it shows me:
Note the post count (138), although it can't seem to find them (No posts found.) ??? They are all in the database, and if I access the post edit page manually, I can see the post, edit the post, do anything I want to the post, except view the post on the site.
It's the same with pages, I can see them in the database, access them manually in the admin, but when I try to view them on the site... 404.
Any thoughts, suggestions?