Merging WordPress posts from different databases

If you never send/sync Production posts to live.

Then just pull/copy the live database to the development database via mysqldump (or similar) and use wp-config vars to force the site and blog URL.

Use the following in the dev versions wp-config.php to force the URL’s

define('WP_HOME','http://example.com');
define('WP_SITEURL', 'http://example.com');

You may as well sync the entire database, rather than just posts, so then you get all the post revisions as well as any plugin configurations/data.

This is my normal method of developing a live site, locally. (Grab live DB drop Dev DB import Live DB into Dev) (The only fun bit is sending specific plugin configs up to the live site from the dev site)

Related Posts:

  1. Database synchronization between dev/staging and production
  2. What actions affect files, DB, or both?
  3. MySQL Database User: Which Privileges are needed?
  4. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  5. Safest way to bulk delete post revisions
  6. How can I make a WordPress database portable and url independent?
  7. Why does $wpdb return strings for mysql integer values?
  8. Dealing with Many Meta Values, 30+
  9. When is it appropriate to create a new table in the WordPress database?
  10. Ways of managing staging and production wordpress sites?
  11. Is it possible to switch the data layer within WordPress?
  12. store simple data in get_option()
  13. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  14. Have multiple local wordpress installs share a wp-content folder and database
  15. How to implement content from external database into WordPress text page? [closed]
  16. Cloning and syncing a WordPress website
  17. Add search Value to wp_list_table pagination
  18. How to fix unchanged URLs in Database after running serialized search and replace script?
  19. Should non-WordPress data get its own DB?
  20. Who is responsible for data sanitization in WordPress development?
  21. Search and replace special characters (å,ä,ö) for image attachments only in database
  22. Localhost to Staging to Development Dynamic WP-CONFIG
  23. Setup 3 Sites To Connect To 1 Database and Share Data
  24. Uknown meta entries in wp_postmeta
  25. Changing between Local Host DB to Production DB and in reverse
  26. creating new field on mysql
  27. Why user_pass column in wp_users table is varchar(64)
  28. Can local WordPress installs share /wp-content/ folder and database?
  29. SymmetricDS in dev + prod workflow?
  30. Database migration issues – Error #1046 No database selected
  31. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  32. WPCLI search and replace in a particlar site dir effect another site-dir
  33. Merging development site with live site
  34. One WP Database outside localhost and two connections
  35. Get id from database
  36. Share WordPress Database
  37. MySQL Database User: Which Privileges are needed?
  38. Checking if Database Table exists
  39. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  40. Is it possible to define two databases for one installation?
  41. Syncing local content with development / staging sites
  42. Export WP database for import using WP-CLI on Vagrant Box
  43. Improve or optimize a very slow query
  44. What is the advantage of separating wp_users and wp_usermeta table?
  45. “MySQL server has gone away” since update to 3.8
  46. WordPress page title repeated in SOME pages
  47. Theme Activation, Create Database Tables
  48. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  49. Custom search page and search by title, content and tag
  50. How to correctly add a table to the WordPress MySQL database
  51. MySQL Syntax Error upon restoring database from backup [closed]
  52. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  53. Automate dir and DB stack creation with WP-CLI
  54. Moving WP from local server to live, error establishing a db connection
  55. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  56. Exporting table to csv works in the admin but exports HTML data when used on the front end
  57. wp search-replace (not executing)
  58. Create table from array with prepare
  59. Migrate database between 2 different wordpress version
  60. SSO system between 2 WordPress installs on different servers
  61. Form that sends data to an admin panel and can export it
  62. Convert user passwords to MD5?
  63. is wordpress stores Role Id in WP database?
  64. Why do database examples sometimes finish with an add_option call?
  65. Does post_meta data need to be unserialzed?
  66. How to backup my site and restore my wordpress site
  67. How to fetch records from database WordPress
  68. How safe is it to delete old posts edits to save database space?
  69. How get Data form wordpress database as array not stdclass?
  70. cannot connect database
  71. Multiple WordPress sites installs sharing the same database but with different content and domains
  72. Brandoo WordPress Unable to Update to WordPress 4.2.2
  73. Connecting to wordpress database in my application [closed]
  74. Remote database -> massive response time increase?
  75. Custom Post Type not showing anything added by code anymore?
  76. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  77. Delete user with only subscriber role
  78. WordPress keeps redirecting to localhost
  79. How to rename custom table name programatically in wordpress?
  80. How to edit custom table data in frontend
  81. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  82. generate PDF from member information
  83. mysqli_query(): MySQL server has gone away for Curl Request
  84. Help posting values to DB on submit using $wpdb->query
  85. create a table using user meta custom data
  86. wpdb query to insert images in to post/page gallery
  87. Creating a database in my plugin not working
  88. How to create index (sql) to a meta_key?
  89. get_user_meta and umeta_id
  90. $wpdb not working
  91. Send data to database after redirect (and popping out of iframe)
  92. Simple email input store in database
  93. Pulling values from a sepcific row in table
  94. import (migration) user database to wp-users
  95. Insert Extra fields added in the front end registration form to DB
  96. WordPress Multisite platform for different city for single db
  97. $wpdb->insert not working for last select option
  98. How to create a table [closed]
  99. Upload wordpress from localhost to 000webhost
  100. WordPress database connection failed, while mysql client is working [closed]
error code: 523