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...