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. WordPress Settings API Overrides My Previous Value
  39. What structure and database storage method should I use for temporary storage that may be written concurrently?
  40. how to access 2nd Mysqli Database from different server for wordpress
  41. adding user_id and name to a separate table whenever a user register based on role
  42. Move Non-WordPress users table to WordPress database
  43. Is there any defects for using same database prefix in WordPress for multiple sites?
  44. Can we store password in without being hashing?
  45. Migrating meta_key and meta_value from old theme to new one
  46. Error establishing a database connection – WordPress setup, everything else is working
  47. Migrating my site to a new domain does not keep any changes made in customizer
  48. Restore of database doesn’t show content
  49. How to check and get json object in WP database?
  50. Why theme settings lost when I installed https
  51. How can I find user role in Mysql?
  52. How do you enable scripts on a WordPress installation in Softaculous?
  53. pre_get_posts causings DB error when using ( ‘posts_per_page’, -1)?
  54. generate PDF from member information
  55. How would I see which wordpress posts have a revision history without opening each one?
  56. SQL database import #1046 error
  57. set_transient fails if the value has more than 60.000 characters
  58. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  59. New Page/Post Screen Opens an Existing Post
  60. How to access a table in a wordpress database using REST API?
  61. Creating a custom form with ability to query and submit to SQL
  62. How do I change several broken URLs in a several wordpress databases in the fastest way?
  63. Change user_nickname for author page link
  64. How do I cleanup my database with data that is no longer being used?
  65. Insert variables into wpdb in custom post template
  66. How to import products in host instead of database on wordpress?
  67. What is recommended data type and encryption type for password in a database
  68. Unable to login to a https website via the app after changing from http
  69. $wpdb->insert duplicating rows
  70. Is there an actual way to synchronize ‘production’ and ‘develop’ WordPress databases?
  71. Lost database connection
  72. How to force set same page as homepage and blogpage in static page settings
  73. mysqli_query(): MySQL server has gone away for Curl Request
  74. How to rerieve comments and their replies from DB
  75. Inserting data with Geometry field
  76. Getting values from form and saving in database but spaces are inserted instead of form values
  77. Troubles when I want to connect to another DB
  78. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  79. WordPress site migration – locked out of admin area
  80. How to extend WP_query to a specific table?
  81. Get all top categories, then only 3 posts for each
  82. Best way to store 1 billion+ posts?
  83. Having all “non-PHP” files on a different server
  84. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  85. syntax error for changing user role from database
  86. Optimize WP site for millions of posts
  87. Advice on how to structure a custom plugin
  88. Is it safe to add INDEX to a column in WordPress database?
  89. Error establishing a database connection with XAMPP
  90. is it possible to install new WordPress in an old WordPress folder?
  91. I Want a More Concice Form of Data than an Array
  92. Malware in old website – how to migrate?
  93. Free version of Relevanssi doesn’t show ACF fields
  94. Can someoene please help with customization of a post?
  95. I would like some help wth an SQL query to link posts with categories
  96. How to have differents sites share the same tables of DB?
  97. Communication in between WordPress database and another (not WordPress) database
  98. How do I loop/iterate through posts to edit all img tags?
  99. Is it possible to separate databases in WordPress site – one for orders and the other for all non-orders related
  100. Error establishing a database connection in wordpress
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)