Merging versions of wp_posts based on post_title

Found it with help from a Twitter follower! Might be handy for others.

Get your backup table and import in to your live DB with a new name, e.g. wp_posts_updated. Then run this query:

UPDATE wp_X_posts LEFT JOIN wp_posts_updated ON wp_posts_updated.post_name = wp_X_posts.post_name SET wp_X_posts.post_content = wp_posts_updated.post_content WHERE wp_posts_updated.post_name = wp_X_posts.post_name

DON’T import your backup wp_posts into multisite using the table name wp_posts! You’ll overwrite a blog’s content.

Related Posts:

  1. find a random blogid across my multisite network that has at least one post published
  2. How to clone and locally run a network for testing
  3. Split a database will improve performance?
  4. Within the database, where is the flag which says that a user has Super Admin rights?
  5. Bulk activate a theme on multisite
  6. Database Tables Lost Indexes? How to Recover?
  7. Will changing the folder name two directories above a fresh wordpress installation break the site?
  8. new multisite, old db
  9. how to migrate wpmu from one host to the other?
  10. WP MultiSite: Can’t select database error after changing to new domain
  11. Get multisite count without php?
  12. WordPress and SQL – Update and Insert from another table if column value doesn’t exist
  13. MySql Database In WordPress Multisite
  14. Plugin data shared in Multisite
  15. How can I trust switch_to_blog()?
  16. DB connection error after copying a WordPress Multisite instance to a second location
  17. what are pmxi tables? [closed]
  18. Shared table across network
  19. WP-CLI methods for get_current_blog_id, get_blog_details or $wpdb->prefix
  20. Multisite: How to store global options vs. site options?
  21. Built to scale, or worry later?
  22. Uploading/Deploying a Multi Site Install
  23. Multisite database upgrade SSL error
  24. Configure WordPress to read from database only, never write
  25. What is the most comprehensive backup plugin for WordPress (it does not have to be free)? [closed]
  26. Multiple Domains and Subdomains Using Multisite Installation
  27. SQL Query to Get list of all users along with their blogs
  28. Is it possible to fix/repair all Index, Primary Key, Unique (and all other) structure of a WordPress MS Database
  29. Migrating WPMS from apache to IIS7 causes Database Error
  30. Copy site from one multisite to another
  31. Synchronizing Two WordPress Sites Content
  32. Two WordPress sites sharing the same database
  33. Recover from failed multisite conversion
  34. WordPress and automated MySQL backups to a different host
  35. Using $wpdb Class to Pull Recent Comments Across a Network
  36. Is it possible to import a wordpress backup from a single site in to a multi-site configuration?
  37. Multisite Subdomain Using More Resources Than Others?
  38. How to change the database prefix in multisite (WPMU) install
  39. Importing Multiple DB to one MU database
  40. What is the best practice to get a site from local to online?
  41. Make WordPress Search for Both Main Domain and Subdomain
  42. Does WordPress MultiSite use separate MySql databases?
  43. Why are no posts showing despite my apparently correct DB restoration?
  44. Bootstrapping WordPress MultiSite Outsite of WordPress – No $wpdb
  45. Is there a way to run upgrade.php for one blog?
  46. Performance on WPMS
  47. What happens if I overwrite the current wp_options table with a backup from a week ago?
  48. Migrating Multisite – Database error, missing wp_blogs table
  49. How to store custom user data on the database?
  50. WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file! [closed]
  51. Removing a wordpress multisite installation and preserving the database before migrate to nginx
  52. Installed domain-based Multisite but can’t access wp-admin (redirect loop)
  53. Pushing stored procedure to a multisite database in WordPress
  54. Multiple multisite instances connecting to the same database
  55. Query to import data from one MultiSite table to another (pages/sub-pages)
  56. Multisite with subfolders- can’t access main site- Error establishing a database connection
  57. Create a database for each site created in multisite?
  58. WordPress Multisite blogs not working after domain swap
  59. 2 website 1 database… Local to online
  60. Obtaining user table for one site on multisite set up
  61. Set up Network Locally on a Flash Drive
  62. Share DB tables between two blogs on the same WP Multisite installation
  63. How many databases do I need?
  64. How do I display offsite database info on my wordpress site?
  65. Locking one blog of many in a multi user/blog WordPress installation
  66. WordPress Multisites or Multiple WP Single sites?
  67. Delete all user’s meta without knowing all the ‘key’
  68. Combining user database tables while keeping all other data in seperate for multiple sites?
  69. How to make multi site with single Database?
  70. Update WP install to WP network & it broke the DB connection
  71. Sharing users across multiple sites, each on their own database
  72. importing data into wordpress db
  73. How to share User Database between Two Multisite Installations + More
  74. add_blog_option blog ID
  75. How long is “as long as possible” in wp_cache_set()?
  76. WPMU on MySQL limited to 1GB of space?
  77. Questions about MU database schema and how to list all blogs
  78. How does WP decide how to evaluate database integrity
  79. How to create a blogs category page with Blog-Types Plugin
  80. Can I use the main Multisite as a backend only?
  81. Problems with WordPress multisite directories/url structures and admin access after migration
  82. Search returns “Nothing Found” on a sub directory
  83. How To Upload Existing WordPress Site To WordPress Multisite Using SSH
  84. WordPress Database Cleanup
  85. Optimal setup for Multi Domain WordPress with Woocommerce
  86. WPCLI search and replace in a particlar site dir effect another site-dir
  87. wordpress multisite – handle Database
  88. Importing Posts into New Website with Same User ID’s
  89. WordPress automatic Login on other page?
  90. How to reconnect database to existing wordpress multisite setup after changing site name
  91. Multi-site database upgrade claims success, but db_version not updated
  92. WordPress Multisite with thousands of blog
  93. Multiple domain with one database
  94. WP DB Location for “Next Post to Create” Index Value
  95. Multisite Tables the same as Single Install?
  96. WordPress Multisite platform for different city for single db
  97. 4th Network Site Database Errors?
  98. Is there a full explanation on how to share a database with two WordPress sites on same server?
  99. HyperDB, Multisite – on new site creation put site’s tables to specific database
  100. Too much slow queries with my multisite