The site URL (www.example.com) hasn't changed. So I exported the wp_posts
table from my old shared hosting server database and imported it into a new WordPress installation on my new dedicated server.
I set the permalink structure in the WordPress installation on the new server to be http://www.example.com/%postname%/
, the same as on the old shared hosting server.
So when I go to an a blog post such as http://www.example.com/blog-post
, nothing displays. I have to go into the admin panel's "Edit" post functionality and then click "Update" before the original post content shows up.
Why might this be? All the data values including the guid are the same...