Merging two wp_posts tables while avoiding duplicates

Import the new table as wp_posts_2, then join them and delete all duplicates based on post_content; then merge the two tables.

The following SQL query (untested!) should give the posts from the new table to be deleted:

SELECT wp2.* FROM wp_posts_2 as wp2 LEFT JOIN wp_posts as wp ON wp2.post_content = wp.post_content WHERE wp2.post_content = wp.post_content

So, you can delete the entries with this query (also untested):

DELETE wp_posts_2.* LEFT JOIN wp_posts as wp ON wp_posts_2.post_content = wp.post_content WHERE wp_posts_2.post_content = wp.post_content

Then merge the two tables.

Related Posts:

  1. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  2. Duplicating Complete WordPress Install for Development and then Redeployment?
  3. How to fix database error duplicate entry
  4. $wpdb->insert Giving duplicates
  5. Select data from foreach loop and send it to wordpress database
  6. Checking if the data already exsis in the wp database – custom plugin
  7. What is this JavaScript “require”?
  8. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  9. get_results using wpdb
  10. How can I make a WordPress database portable and url independent?
  11. wpdb->insert multiple record at once
  12. How to migrate a HTTPS WordPress installation to localhost?
  13. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  14. How to monitor server for error establishing a database connection
  15. How to create bulk page and content? [closed]
  16. Default WordPress settings API data sanitization
  17. Fatal error: Call to undefined function dbDelta()
  18. Connect to remote database using Localhost install
  19. remove missing image attachments
  20. Transient RSS feeds in wp_options not removed automatically?
  21. Best way to move live site local
  22. The revisions table in my database is at 70% capacity and growing. What should I do?
  23. WordPress for a very large website
  24. How to ensure data consistency in WordPress
  25. Database location in WordPress
  26. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  27. WP_list_table bulk_action get edit and delete
  28. How to display data from custom table in wordpress database?
  29. How to intercept update_option() before it saves data?
  30. Change SQL get_results to search for posts with custom term in custom taxonomy
  31. wpdb query on custom table not working [closed]
  32. How to diagnose and keep in check encoding issues?
  33. Add search Value to wp_list_table pagination
  34. stdObject stored in database. How does one convert it to usable format?
  35. I have a table I created, how do I make a form for a user to filter the data?
  36. How to fix unchanged URLs in Database after running serialized search and replace script?
  37. wp_redirection_404 table has grown to 7GB
  38. Does WordPress ever need multiple databases?
  39. Why are no posts showing despite my apparently correct DB restoration?
  40. WordPress database error – Error in SQL syntax – I can’t identify any error?
  41. Multiple wp_options tables to share content across installs
  42. Saving into post_excerpt or post_content
  43. Maintain user profile data in a non-WordPress database
  44. How to fix the disappearance of the “\” character when updating a post in the database
  45. How to scan barcode and store data into a database [closed]
  46. Fetching values from database for select box
  47. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  48. Setup private content for specific users with daily updates [closed]
  49. fastest replacement DB
  50. Connection refused on locahost after importing database?
  51. When to use custom DB tables or add_option?
  52. Have working sql query… trying to adjust it to use $wpdb
  53. creating new field on mysql
  54. Does WordPress store the username as a primary key in the database?
  55. Strange characters added to the database
  56. WSOD 3.9.1 – Tried Everything so far
  57. Database Update Required – Update from command-line
  58. Can you refresh ONLY the wordpress adminbar and not the whole page?
  59. Sending posts from Python to WordPress
  60. Problem migrating to localhost
  61. SQL query to set posts in bulk based on the post content
  62. Automate WordPress website setup with prefilled data
  63. Custom search query by category id
  64. How do you render posts from outside wordpress?
  65. Image link issues after importing a database backup to my local web server
  66. multiple wordpress installs w/shared user database but separate content databases
  67. Second ezSQL initialization for MSSQL
  68. Fetch a single row from a custom table for to a given ID
  69. Database create or redirect
  70. Updating seperate database when post attachment is changed
  71. add featured image dialog box disappear
  72. Database structure cheatsheet
  73. White Screen in Home Page
  74. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  75. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  76. How to get a list of articles related to a particular category from my other WordPress website?
  77. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  78. Malware in old website – how to migrate?
  79. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  80. error establishing database connection (WAMP + filezilla)
  81. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  82. How do I update a WordPress wp_postmeta meta_value that contains many options
  83. How can I get $wpdb to show MySQL warnings?
  84. About wp database hooks (error establishing connection)
  85. How to display $wpdb->insert_id; value on redirected page
  86. Should I Use only wpdb Class to Write Custom Queries?
  87. Auto populate form fields based on serial input or pull listings from other websites?
  88. How to extract some part of WordPress full source code
  89. Error establishing a database connection for some files
  90. Hash user emails in database?
  91. Weird characters in title if it contain “ ”
  92. Share WordPress Database
  93. DB access blocked when initializing WP externally
  94. Saving data to database and exporting to excel
  95. Site does not work right, pages not showing up, even for root admin
  96. One information repeated on multiple locations on one site [closed]
  97. WordPress: Interact with Database Query Data and Login
  98. Showing Error(TAble already exist)
  99. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  100. WP Multisite Users Not Linking