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:
- Manually removing revision post types
- SQL Query for getting all posts in their latest revised state
- Reset/Reorder posts ID in the MySQL wp_posts table
- How to store an extra (surrogate) ID when creating a post with wp_insert_post?
- How do I find which articles are missing a featured image in The WordPress database?
- Define a wordpress constant through plugin functions?
- Remove a shortcode from all WordPress posts
- What do these phpMyAdmin errors mean on my WordPress databaes?
- why there are so many posts whoes post_type is revision? will these records waste too much database space?
- Why my wp_posts data is so huge?
- Delete post revisions only for a single post
- Restore woocommerce orders
- How to select particular month post from table and update the post status using MySQL?
- Get author posts count after excluding a category
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Clean up customize_changeset in DB
- SQL trigger failes with post_content
- Converting Posts to Pages
- How to change the publishing date of each posts?
- Where is the old post permalink slug stored?
- MySQL Query to Retrieve Category from wp_posts
- How does WordPress handle MySQL row lock errors?
- Listen to Post action
- How are terms connected with posts in database?
- Manipulate post category after time
- Moving WordPress to new server: no posts found
- Manually delete post from database
- how to enable different number of revisions for different blogs when using WPMU?
- How to force update all posts after import
- Cannot access current post’s ID in custom plugin
- Set number of article per number of page
- How to change post status from publish to draft using hook in wordpress?
- prevent showing posts of an specific category in admin posts section
- Sanitizing `wp_editor();` Values for Database, Edit, and Display
- Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
- Insert posts in two tables
- Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
- Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
- How to migrate the posts from an old custom legacy blog to a new WordPress website?
- Adding a cancel button to edit post screen
- Global $post not working in OOP function WordPress
- Most recent post from another database
- What structure should post_content have in the database?
- Post revisions disappeared (for some posts)
- How to delete all the content of a wordpress site without deleting the Post and pages?
- wp_insert_post – duration
- Help With MySQL to WPDB Query Conversion
- How to hide html tags on revision comparison pages?
- Prevent Delete Attachment by URL or When Submit
- WordPress Backend HA (Automatic failover)
- Visual (non-HTML) display of post revisions [closed]
- Custom order for Mysql array
- wp_posts table: safely remove unused columns to save database storage
- Display post changelog in post
- Is it possible to use WP_Query to only pull posts with attachments?
- Get posts and include taxonomy term
- Add field to user meta table in database when link is clicked
- wpdb prepare insert table doesn’t work
- How safe is it to delete old posts edits to save database space?
- Using AND and bracket grouping in SQL not working
- wp_posts table extremely large
- Filter Hook for post table (not columns)
- How to Assign / Move all Deleted post to a category
- Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
- DB Query not working in Plugin
- Saving Post Data in Another Database
- Queries take 120+ seconds on my large WordPress site
- Database hacked – random posts are modified
- What might be the reason of Couldn’t fetch mysqli_result on another domain?
- How do post IDs work in WordPress?
- Stop post submission without losing data?
- Cant’ Grab WordPress Built-in Posts Through Loop
- How can my plugin display a populated new post window
- search content of pages and list in wp-admin
- Import custom database into wp and keep the post id
- Insert specific information to a posts of a predefined category
- Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
- query for filtering published posts?
- Help on conditional statement to accompany wp_insert_post function please?
- How can I globally italicize list of texts in the UI database or Posts? [closed]
- Menu Items disappearing/being empty on save or post edit
- Query to fetch custom taxonomy along with post title
- Mysql update menu_order problem
- Prevent a post with a specific ID from being created
- ‘posts’ table should not store the absolute image path
- More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
- WordPress doesn’t create table on plugin activation
- how i show manual data in a post
- How do I change the post title’s link on the posts page?
- pull data from wordpress database
- Maximum number of posts per page before affecting performance?
- How to filter get_adjacent_post()?
- get backup file from wordpress database in x days
- SQL query to remove first image in all posts
- Given two custom post types: Automatically add meta fields from one custom post type to another
- Delete junk text from all the post using my sql command
- Hide the contents for specific post
- If meta_key exists then don’t select this post?
- Error 404 blog/page/2/
- Restore posts, but only posts that exist in my database backup