Importing New Posts from Live Site into Local Dev Site

Have you considered to use REST API to bridge the two environments?

Basically you need to hit the posts endpoint https://example.com/wp-json/wp/v2/posts using the after argument that permit to limit response to posts published after a given ISO8601 compliant date.

With the response you can insert new posts and sync the two installation.

More detail about the endpoint and the arguments can be found here https://developer.wordpress.org/rest-api/reference/posts/

Related Posts:

  1. How can I export WordPress posts’ attachments?
  2. How much of my site can I recover from public_html?
  3. WordPress Local And Live Site
  4. When moving a WordPress installation to a new server, why do I have to update each post before content shows?
  5. Moving WordPress to new server: no posts found
  6. How can I export and then import posts with featured images?
  7. Exporting Data from WordPress into a flat table
  8. Merging two databases without borking it
  9. Overwrite posts/pages via import
  10. Importing posts only – consequences?
  11. Move posts from a non-wordpress site to wordpress
  12. My website is showing today’s date instead of published date since db migration to a new wordpress
  13. Featured image error after importing blog posts
  14. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  15. When I click edit on a post, all the content disappear. Does anyone know how to fix this?
  16. Moving Posts to a new site and maintaining URLs
  17. Export Posts Without Categories In An XML File
  18. How do you export and import wordpress blog posts and exclude pagebuilder shortcodes?
  19. Can posts have parents?
  20. Where is the old post permalink slug stored?
  21. Separate Database Tables For Different Post Types
  22. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  23. Export WP database for import using WP-CLI on Vagrant Box
  24. How to migrate a WordPress installation from one site to another, including all images?
  25. How to force update all posts after import
  26. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  27. Does WordPress Import/Export tool actually exports media (images) as well?
  28. MySQL Syntax Error upon restoring database from backup [closed]
  29. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  30. Insert posts in two tables
  31. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
  32. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  33. Reset/Reorder posts ID in the MySQL wp_posts table
  34. How do I find which articles are missing a featured image in The WordPress database?
  35. Split WP_POST table based on post types
  36. Most recent post from another database
  37. What structure should post_content have in the database?
  38. How to modify post content?
  39. Create a clone from one WordPress site to another in a few minutes
  40. Polylang post_translations key [closed]
  41. Import users from old WP site to new one
  42. What is the difference between wp-admin>Export>All content and MySql dump and import
  43. Can I search posts and pages for css classes?
  44. Unable to restore from backup – how to obtain old blog posts?
  45. Transferring WordPress Database – Serialised data
  46. Emojis replaced by ‘?’ automatically
  47. Export + Import = wrongly duplicated content
  48. Problems with WordPress Import
  49. When open add new post or page WordPress add post with ID=0 continuously [closed]
  50. wp_posts table: safely remove unused columns to save database storage
  51. Anyone know why wordpress converts some html entities to their numeric equivalents?
  52. Remove a shortcode from all WordPress posts
  53. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  54. How to transform a custom made static HTML website to a WordPress website [closed]
  55. Is it possible to use WP_Query to only pull posts with attachments?
  56. Get posts and include taxonomy term
  57. Add field to user meta table in database when link is clicked
  58. How safe is it to delete old posts edits to save database space?
  59. Best practice to import user base (subscribers) from one website to another?
  60. Importer fails to import every post
  61. How to import nested categories from XML file?
  62. Delete post revisions only for a single post
  63. How to Assign / Move all Deleted post to a category
  64. Display post number by category
  65. Output Post with ACF Fields into other Post
  66. Saving Post Data in Another Database
  67. Restore woocommerce orders
  68. Update field in database for users
  69. Is it good practice to import/export a blog to test a redesign?
  70. Cannot select certain authors for posts after import
  71. Import custom database into wp and keep the post id
  72. product export and import using xml
  73. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  74. Help on conditional statement to accompany wp_insert_post function please?
  75. Can I restore restore content from old Worpress site to a new Worpress site from an archive
  76. Is it possible to modify posts table to only read for more recent ones?
  77. Bulk Edit Media Library alt, caption, image names
  78. Menu Items disappearing/being empty on save or post edit
  79. How to setup default value of post_id
  80. Prevent a post with a specific ID from being created
  81. Reusing old post IDs
  82. Trigger on DB make problem on wordpress?
  83. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  84. Maximum number of posts per page before affecting performance?
  85. SQL trigger failes with post_content
  86. get backup file from wordpress database in x days
  87. Migrate bbpress content to posts
  88. Given two custom post types: Automatically add meta fields from one custom post type to another
  89. I broke database after reuploading local version – what exactly happened? Database error
  90. How do I get the WordPress post to display the content instead of an image?
  91. Tumblr importer
  92. Is there a maximum amount of pages for a multi-page post?
  93. What effect can a large wp_post table have on overall site performance?
  94. Can`t Access Post Page After Migration
  95. Imported Posts missing summary text on staging site
  96. Change permalinks in posts via SQL
  97. Does WordPress import export tool keeps the file hosted on the old website?
  98. Is it safe to totally unregister the default “post” Post Type
  99. How to get a list of all posts and their categories?
  100. How to manually delete post from database without causing conflicts?