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. Where is the old post permalink slug stored?
  19. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  20. Best way to import users, post and categories from an external database
  21. Export WP database for import using WP-CLI on Vagrant Box
  22. How are terms connected with posts in database?
  23. How to migrate a WordPress installation from one site to another, including all images?
  24. How to force update all posts after import
  25. How to migrate WordPress Blogs into Multisite without using the GUI-Import/Export Feature
  26. Importing data from spreadsheet into wordpress DB, along with custom taxonomies and their terms
  27. Suggestions for WPMU Migration (advanced)
  28. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  29. MySQL Syntax Error upon restoring database from backup [closed]
  30. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  31. Insert posts in two tables
  32. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
  33. ‘Invalid post type’ error when importing from one site to another
  34. Export posts manually selected by end user (not logged in)
  35. Reset/Reorder posts ID in the MySQL wp_posts table
  36. Most recent post from another database
  37. What structure should post_content have in the database?
  38. How to delete all the content of a wordpress site without deleting the Post and pages?
  39. Extracting post categories
  40. Export / import WordPress database
  41. Create a clone from one WordPress site to another in a few minutes
  42. How do I migrate blog post images from one domain to a new one?
  43. Get ALL post ID’s export list (Only id’s. Php or sql not important )
  44. Import users from old WP site to new one
  45. Can I search posts and pages for css classes?
  46. Unable to restore from backup – how to obtain old blog posts?
  47. Export + Import = wrongly duplicated content
  48. Move comments only from one WP installation to another
  49. Problems with WordPress Import
  50. Copy post to separate database with “add_action(….)”
  51. When open add new post or page WordPress add post with ID=0 continuously [closed]
  52. Anyone know why wordpress converts some html entities to their numeric equivalents?
  53. Remove a shortcode from all WordPress posts
  54. What do these phpMyAdmin errors mean on my WordPress databaes?
  55. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  56. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  57. How to transform a custom made static HTML website to a WordPress website [closed]
  58. Delete all drafts?
  59. Is it possible to use WP_Query to only pull posts with attachments?
  60. Get posts and include taxonomy term
  61. Add field to user meta table in database when link is clicked
  62. How safe is it to delete old posts edits to save database space?
  63. Best practice to import user base (subscribers) from one website to another?
  64. Importer fails to import every post
  65. Delete post revisions only for a single post
  66. wp_posts table extremely large
  67. How to Assign / Move all Deleted post to a category
  68. Saving Post Data in Another Database
  69. Restore woocommerce orders
  70. Is it good practice to import/export a blog to test a redesign?
  71. Cannot select certain authors for posts after import
  72. Import custom database into wp and keep the post id
  73. why the posts queried from sql is more than those showed on the page?
  74. product export and import using xml
  75. Export WordPress from one domain to another domain
  76. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  77. Is there a function to get post info for any publish_status by post ID?
  78. Help on conditional statement to accompany wp_insert_post function please?
  79. How can I globally italicize list of texts in the UI database or Posts? [closed]
  80. Bulk Edit Media Library alt, caption, image names
  81. Syncing WP Database Changes Between Environments: How To Handle Merging w/o touching database
  82. Menu Items disappearing/being empty on save or post edit
  83. Prevent a post with a specific ID from being created
  84. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  85. how i show manual data in a post
  86. Maximum number of posts per page before affecting performance?
  87. SQL trigger failes with post_content
  88. get backup file from wordpress database in x days
  89. Expired Post with More Recent Time Stamp?
  90. Update all images url imported from HTML pages
  91. Converting Posts to Pages
  92. How to change the publishing date of each posts?
  93. Migrate bbpress content to posts
  94. Given two custom post types: Automatically add meta fields from one custom post type to another
  95. I broke database after reuploading local version – what exactly happened? Database error
  96. How do I get the WordPress post to display the content instead of an image?
  97. Load posts from external source if not found in database
  98. Importing Concrete5 content to WordPress
  99. How can I merge a several related posts into one post?
  100. Restore posts, but only posts that exist in my database backup
error code: 523