Is removing orphaned wp_postmeta records safe?

A different way of doing this (not better, but easier to follow) would be:

DELETE * FROM wp_postmeta WHERE post_id NOT IN (SELECT ID FROM wp_posts)

Obviously changing the prefixes from ‘wp_’ to whatever your setup uses

Related Posts:

  1. WooCommerce – Query for ordered products
  2. Delete transients in website
  3. Structure of postmeta meta_value for woocommerce product download
  4. Cleanup: best way to remove WooCommerce comments from the wp_comments table
  5. WooCommerce: remove sample & dummy data
  6. Woocommerce – Check product stock availability from external database
  7. What is table `wp_woocommerce_termmeta` for? [closed]
  8. What is this JavaScript “require”?
  9. Using wpdb to connect to a separate database
  10. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  11. get_results using wpdb
  12. How can I make a WordPress database portable and url independent?
  13. wpdb->insert multiple record at once
  14. How to migrate a HTTPS WordPress installation to localhost?
  15. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  16. How to monitor server for error establishing a database connection
  17. Exporting revisions
  18. WP_Options ID high
  19. Default WordPress settings API data sanitization
  20. Fatal error: Call to undefined function dbDelta()
  21. Connect to remote database using Localhost install
  22. remove missing image attachments
  23. How to use multiple database in wordpress?
  24. Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?
  25. How to ensure data consistency in WordPress
  26. How to write Hebrew characters?
  27. Error establishing a database connection – with Debug Data
  28. Finding the login page from database?
  29. Does thumbnail regeneration edit the database?
  30. When and why should I use $wpdb different return types?
  31. Database with mixed collation (utf8mb4 & utf8_general_ci)
  32. Delete all post meta except featured image Using SQL
  33. WordPress doesn’t show all posts in database
  34. Adding new row to wp_post table
  35. Extracting the post_id via the wp_insert_post action (external db query)
  36. How to interact with another wordpress install on same database?
  37. Are custom tables in the database overwritten when WordPress is updated to new versions?
  38. What is the proper way to validate and sanitize JSON response from REST API?
  39. How do I get the posts within a certain year/date(with sql query)?
  40. batch UPDATE autoload value in wp_options table
  41. Displaying BLOB PDF File
  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 select from two different tables to display orders list with custom column from other table
  46. Data storage for JS app using WP REST API
  47. Update from 4.5 to 4.6 failing
  48. Setup 3 Sites To Connect To 1 Database and Share Data
  49. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  50. Setup private content for specific users with daily updates [closed]
  51. Does auto_load to ‘no’ in wp_options improve performance
  52. Connection refused on locahost after importing database?
  53. creating new field on mysql
  54. Is it possible to rebuild the website while not accesseing the original database?
  55. Error message on blog posts only on my local environment [closed]
  56. how to read database fields
  57. $wpdb->query can’t insert data
  58. WSOD 3.9.1 – Tried Everything so far
  59. Can you refresh ONLY the wordpress adminbar and not the whole page?
  60. Sending posts from Python to WordPress
  61. Problem migrating to localhost
  62. SQL query to set posts in bulk based on the post content
  63. Automate WordPress website setup with prefilled data
  64. How can I detect right db type?
  65. Add search bar to Custom Database Table in WordPress Dashboard
  66. Design problems when exporting remote database for local development
  67. How do you render posts from outside wordpress?
  68. A change in URL slug in database returns 404, how can I do auto-redirect?
  69. Second ezSQL initialization for MSSQL
  70. Fetch a single row from a custom table for to a given ID
  71. Database create or redirect
  72. Database structure cheatsheet
  73. White Screen in Home Page
  74. Continuous SQL query errors from outside source
  75. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  76. Recovery – Restore Database after moving folder location locally
  77. Migrate Users From laravel to wordpress
  78. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  79. how add more field to wp user and save it to database
  80. Deleted products from woocommerce are still in the database
  81. How do I cleanup my database with data that is no longer being used?
  82. Malware in old website – how to migrate?
  83. error establishing database connection (WAMP + filezilla)
  84. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  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. Wrong url for the images while using same database for two WordPress installations
  90. Error establishing a database connection for some files
  91. Hash user emails in database?
  92. Sending WordPress database information to cross domain the safe way?
  93. Database Name Change
  94. Weird characters in title if it contain “ ”
  95. Where To Find bb_profile_data(); In bbPress?
  96. Saving data to database and exporting to excel
  97. One information repeated on multiple locations on one site [closed]
  98. Showing Error(TAble already exist)
  99. SQL query to rewrite all media URLs to end with .webp
  100. Weird WP -Cli Error Connection Refused

Leave a Comment