What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?

You can also do it this way – plugin free.

Open phpmyadmin, browse over to your wp_posts table and:

SELECT * FROM `wp_posts` WHERE post_type="revision";
to see all the posts, their types and revisions and
delete from `wp_posts` WHERE post_type="revision"

Though afraid at first…I did it. And it worked without any impact to the site.

Related Posts:

  1. Manually removing revision post types
  2. SQL Query for getting all posts in their latest revised state
  3. Reset/Reorder posts ID in the MySQL wp_posts table
  4. How to store an extra (surrogate) ID when creating a post with wp_insert_post?
  5. How do I find which articles are missing a featured image in The WordPress database?
  6. Define a wordpress constant through plugin functions?
  7. Remove a shortcode from all WordPress posts
  8. What do these phpMyAdmin errors mean on my WordPress databaes?
  9. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  10. Why my wp_posts data is so huge?
  11. Delete post revisions only for a single post
  12. Restore woocommerce orders
  13. How to select particular month post from table and update the post status using MySQL?
  14. Get author posts count after excluding a category
  15. Bulk find & replace on WordPress posts/pages (minus image paths)
  16. Clean up customize_changeset in DB
  17. SQL trigger failes with post_content
  18. Converting Posts to Pages
  19. How to change the publishing date of each posts?
  20. How to manually delete post from database without causing conflicts?
  21. When is the ‘post_content_filtered’ column in database cleared by WordPress?
  22. How to add an admin notice upon post save/update
  23. Getting wrong relationship value in $args in wp_Query?
  24. How can I safely increase the character limit for post passwords?
  25. How to Group Posts by the First Letter or Number?
  26. Restore contents of deleted user
  27. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  28. How is the data stored in the database?
  29. WooCommerce – Create Products Programatically [closed]
  30. How do I write this SQL statement for Posts written in last 24 hours?
  31. Custom Taxonomies Incorrectly Counting Revisions?
  32. database columns: post_title vs post_name
  33. Using radio button meta data from a custom meta box
  34. Tons of Twitter rows in my database
  35. Importing New Posts from Live Site into Local Dev Site
  36. How much of my site can I recover from public_html?
  37. Enable post revisions for a specific post
  38. Tags to Post-ID mysql query. Tag Search
  39. Multiples Empty Posts were created and cannot delete them
  40. WordPress database error for query INSERT INTO
  41. How to connect to AWS RDS external database (not for the core WordPress db)
  42. How to get post bulk edit action trigger and get edited post ids?
  43. Extracting post categories
  44. Update results, Before deleting the related category [closed]
  45. updating a post doesn’t trigger a function
  46. Hide a specific category in admin All Posts page (WordPress)
  47. What hook do you use to update a post?
  48. Updating post data on save (save_post vs wp_insert_post_data)
  49. Get user categories with most posts in it
  50. MySql query to get posts with all meta and terms
  51. Can’t update old posts 3.5.2
  52. Copy post to separate database with “add_action(….)”
  53. List authors with the last post title and order by last post date
  54. When open add new post or page WordPress add post with ID=0 continuously [closed]
  55. Anyone know why wordpress converts some html entities to their numeric equivalents?
  56. How to Mysql select a list of posts with meta_values AND all relevant categories?
  57. Order posts alphabetically: how to set order=asc in mysql query?
  58. Delete all drafts?
  59. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  60. update image path with words starting uppercase to lowercase chars
  61. wpdb prepare insert table doesn’t work
  62. Move posts from a non-wordpress site to wordpress
  63. wp_posts table extremely large
  64. Filter Hook for post table (not columns)
  65. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  66. why str_replace targeting pages instead just targeting post?
  67. Queries take 120+ seconds on my large WordPress site
  68. select a single val though a table in wordpress
  69. Finding a post’s slug
  70. Insert specific information to a posts of a predefined category
  71. Integrating Custom Database with WordPress
  72. why the posts queried from sql is more than those showed on the page?
  73. How to display results from a data table with an encrypted user id?
  74. WordPress database error: [Query was empty] – using $wpdb->prepare()
  75. Is there a function to get post info for any publish_status by post ID?
  76. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  77. How Can I Always Display A Particular Post First Using WP_Query?
  78. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  79. Deleting post tags removes categories
  80. How can I globally italicize list of texts in the UI database or Posts? [closed]
  81. My website is showing today’s date instead of published date since db migration to a new wordpress
  82. How can I change the date format of the revision list?
  83. MYSQL: Create SQL query to search for string and replace
  84. WordPress: Develop multiple posts with different data
  85. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  86. load post data into mysql
  87. how i show manual data in a post
  88. Maximum number of posts per page before affecting performance?
  89. Fixing the WP Post Object for Custom Route
  90. Surrogate ID for posts, is there an alternative field in the posts table?
  91. Expired Post with More Recent Time Stamp?
  92. Extra field in wp_post instead of postmeta
  93. Voting System, database connections?
  94. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  95. Load posts from external source if not found in database
  96. Onclick open posts displayed in slider in a popup [closed]
  97. How can I delete the options from DB when the plugin is deleted?
  98. Change permalinks in posts via SQL
  99. Is it safe to totally unregister the default “post” Post Type
  100. How to get a list of all posts and their categories?