When moving a WordPress installation to a new server, why do I have to update each post before content shows?

jdm2112 identified the issue as being caused by missing tables as part of the migration process within the comments for the original question:

You imported just the single table into another WordPress DB? THAT is
the problem. Post IDs are unique between sites… I would avoid
working with individual tables unless absolutely necessary

After migrating the rest of the tables, Nona reports that this issue has been resolved:

Thanks… I moved the wp_terms, wp_term_relationships, and
wp_term_taxonomy in addition to the wp_posts table and now
everything appears to work.

Related Posts:

  1. How can I export WordPress posts’ attachments?
  2. Importing New Posts from Live Site into Local Dev Site
  3. How can I export and then import posts with featured images?
  4. How much of my site can I recover from public_html?
  5. WordPress Local And Live Site
  6. Overwrite posts/pages via import
  7. Importing posts only – consequences?
  8. Featured image error after importing blog posts
  9. Moving Posts to a new site and maintaining URLs
  10. Export Posts Without Categories In An XML File
  11. Moving WordPress to new server: no posts found
  12. Migrating WP site to another URL
  13. How to migrate a WordPress installation from one site to another, including all images?
  14. How to force update all posts after import
  15. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  16. Importing data from spreadsheet into wordpress DB, along with custom taxonomies and their terms
  17. Does WordPress Import/Export tool actually exports media (images) as well?
  18. Exporting Data from WordPress into a flat table
  19. ‘Invalid post type’ error when importing from one site to another
  20. Export posts manually selected by end user (not logged in)
  21. How do I migrate blog post images from one domain to a new one?
  22. Get ALL post ID’s export list (Only id’s. Php or sql not important )
  23. Merging two databases without borking it
  24. Polylang post_translations key [closed]
  25. What is the difference between wp-admin>Export>All content and MySql dump and import
  26. Can I search posts and pages for css classes?
  27. Unable to restore from backup – how to obtain old blog posts?
  28. Export + Import = wrongly duplicated content
  29. Move comments only from one WP installation to another
  30. Problems with WordPress Import
  31. How to import nested categories from XML file?
  32. Move posts from a non-wordpress site to wordpress
  33. Output Post with ACF Fields into other Post
  34. Extract wordpress posts content and category content
  35. Cannot select certain authors for posts after import
  36. product export and import using xml
  37. Extract the last published post
  38. Export WordPress from one domain to another domain
  39. Can I restore restore content from old Worpress site to a new Worpress site from an archive
  40. How do you do your big exports / imports?
  41. Syncing WP Database Changes Between Environments: How To Handle Merging w/o touching database
  42. My website is showing today’s date instead of published date since db migration to a new wordpress
  43. Posts not showing content after migration
  44. Update all images url imported from HTML pages
  45. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  46. When I click edit on a post, all the content disappear. Does anyone know how to fix this?
  47. Migrate bbpress content to posts
  48. How do I get the WordPress post to display the content instead of an image?
  49. Tumblr importer
  50. Can`t Access Post Page After Migration
  51. Imported Posts missing summary text on staging site
  52. Does WordPress import export tool keeps the file hosted on the old website?
  53. Use category base slug in posts’ permalink
  54. Customizing HTML Editor Quicktags button to open a dialog for choosing insert options
  55. Sends out email to admin
  56. Get title of post without using the_title();
  57. Find most recent authors
  58. How to add a custom button to the tinyMCE toolbar?
  59. How to add one time a new page?
  60. Enable commenting on front-end preview page for pending posts
  61. why does HTML Tag not working in Post and Page
  62. How to place HTML below the title of the (custom) post overview
  63. A way to detect which page a post is on
  64. Checking if a post with certain meta value exists
  65. AJAX filter posts by year
  66. Animated gif for a thumbs
  67. I am unable to publish/update post
  68. filter RSS feed in URL
  69. What hook do you use to update a post?
  70. sql select for post_title and a term name
  71. Count number of posts of current month
  72. Removing Extra Caption tag around image on post of WordPress
  73. How to create a page that shows the last 10 posts?
  74. How to display posts on custom page without declaring a posts page in reading settings?
  75. the_content() Not Grabbing All Content
  76. How to check if there are posts with the same tag
  77. Can i have more than one form for front end posting in one template [closed]
  78. How do I allow certain users to make a certain type of post?
  79. How to make blog posts have their own urls?
  80. Transferring theme and imported post attachments
  81. How to add content above footer in posts from specific category
  82. Show posts from two specific category in WP_Query
  83. How to pull latest posts from a specific category
  84. How to create a button to filter posts (list) by meta value
  85. How to make certain posts not appear on the main page, but instead only a newly created category(in the menu section)
  86. Not able to post data through wp-admin
  87. AJAX load more posts not using correct category and repeating the same few posts
  88. Post by Email – Shortcode for Language? [closed]
  89. Difficulty in creating and handling a complex post type
  90. Admin is showing all posts on page 1
  91. Display only current page -> posts tags in page
  92. 3rd Party Login in wordpress
  93. How to mix pages and sub-categories in a url
  94. Overwrite URL on blog posts
  95. WordPress 3.2 – Problem with WYSIWYG editors in a custom post type?
  96. 301 Redirecting posts without %postid% (just %post_name%) in permalink to ones with %post_name%_%postid%
  97. I am creating a front end dashboard where I need to show all the posts by the current user. So, I need to show posts in publish
  98. Display draft posts on single pages [duplicate]
  99. query_posts different amount of posts per page [duplicate]
  100. How to automatically convert a form with HTML link into post