Manually removing revision post types

IF you want, you can disable revisions in first place (No need to run CRON then)

To disable them go to wp-config.php and add this line:

define('WP_POST_REVISIONS', false );

Or to limit to 10 revisions

define('WP_POST_REVISIONS', 10);

And to delete all current revisions you can run this SQL query:

DELETE FROM wp_posts WHERE post_type = "revision";

Here seems to be quite decent plugin to do that for you (It does a lot more too)
https://wordpress.org/plugins/rvg-optimize-database/

Also DO backups

And another SO thread:
Safest way to bulk delete post revisions

Related Posts:

  1. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  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 do I find which articles are missing a featured image in The WordPress database?
  5. Remove a shortcode from all WordPress posts
  6. What do these phpMyAdmin errors mean on my WordPress databaes?
  7. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  8. Why my wp_posts data is so huge?
  9. Delete post revisions only for a single post
  10. Restore woocommerce orders
  11. How to select particular month post from table and update the post status using MySQL?
  12. Bulk find & replace on WordPress posts/pages (minus image paths)
  13. Clean up customize_changeset in DB
  14. SQL trigger failes with post_content
  15. Converting Posts to Pages
  16. How to change the publishing date of each posts?
  17. How to manually delete post from database without causing conflicts?
  18. When is the ‘post_content_filtered’ column in database cleared by WordPress?
  19. Can posts have parents?
  20. Where is the old post permalink slug stored?
  21. Separate Database Tables For Different Post Types
  22. MySQL Query to Retrieve Category from wp_posts
  23. How can I safely increase the character limit for post passwords?
  24. How to Group Posts by the First Letter or Number?
  25. Restore contents of deleted user
  26. How are terms connected with posts in database?
  27. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  28. Saving Post Data in Another Database
  29. Queries take 120+ seconds on my large WordPress site
  30. Database hacked – random posts are modified
  31. Need to change all links in page content but not in post content
  32. Can’t update WordPress Page if post_content is Empty
  33. How do post IDs work in WordPress?
  34. Why when I create a new post I found 2 record related to this post into the posts database table?
  35. Get author posts count after excluding a category
  36. Update field in database for users
  37. Import custom database into wp and keep the post id
  38. why the posts queried from sql is more than those showed on the page?
  39. get last post’s link with SQL query
  40. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  41. Is there a function to get post info for any publish_status by post ID?
  42. query for filtering published posts?
  43. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  44. How Can I Always Display A Particular Post First Using WP_Query?
  45. Help on conditional statement to accompany wp_insert_post function please?
  46. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  47. Deleting post tags removes categories
  48. How can I globally italicize list of texts in the UI database or Posts? [closed]
  49. Is it possible to modify posts table to only read for more recent ones?
  50. Return records between two meta datetimes saved as strings
  51. WP query taxonomy optimization
  52. Menu Items disappearing/being empty on save or post edit
  53. My website is showing today’s date instead of published date since db migration to a new wordpress
  54. How can I change the date format of the revision list?
  55. MYSQL: Create SQL query to search for string and replace
  56. Query to fetch custom taxonomy along with post title
  57. How to setup default value of post_id
  58. Mysql update menu_order problem
  59. Prevent a post with a specific ID from being created
  60. Reusing old post IDs
  61. Trigger on DB make problem on wordpress?
  62. WordPress MySQL Search and replace with wildcard?
  63. Comments are in database, don’t show up in WordPress backend or frontend
  64. Is there a way to save different data when USER interacts with the same POST?
  65. Add postmeta to all blog posts
  66. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  67. ‘posts’ table should not store the absolute image path
  68. Dev and prod on the same database- dev version active for IOS
  69. load post data into mysql
  70. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  71. how i show manual data in a post
  72. How do I get a certain set of posts from the database?
  73. Maximum number of posts per page before affecting performance?
  74. Surrogate ID for posts, is there an alternative field in the posts table?
  75. get backup file from wordpress database in x days
  76. Expired Post with More Recent Time Stamp?
  77. I moved my site to another server, wp admin works so does the front page, but posts don’t work
  78. Can’t seem to replicate permalink structure for localhost development site
  79. Extra field in wp_post instead of postmeta
  80. Voting System, database connections?
  81. When I click edit on a post, all the content disappear. Does anyone know how to fix this?
  82. SQL query to remove first image in all posts
  83. Given two custom post types: Automatically add meta fields from one custom post type to another
  84. Delete junk text from all the post using my sql command
  85. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  86. Load posts from external source if not found in database
  87. How to create a post based on data in a table?
  88. Is there a maximum amount of pages for a multi-page post?
  89. If meta_key exists then don’t select this post?
  90. How to make category for word post_content
  91. What effect can a large wp_post table have on overall site performance?
  92. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  93. How can I merge a several related posts into one post?
  94. Restore posts, but only posts that exist in my database backup
  95. Change permalinks in posts via SQL
  96. Is it safe to totally unregister the default “post” Post Type
  97. How to get a list of all posts and their categories?
  98. WordPress Post Query Using Custom native MySQL like St_Distance_Sphere
  99. Can’t save/get Patterns’ `post_content` attribute
  100. How to extract and reveal code from SQL database in WordPress
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)