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?
- How to manually delete post from database without causing conflicts?
- When is the ‘post_content_filtered’ column in database cleared by WordPress?
- How to add an admin notice upon post save/update
- Can posts have parents?
- Where is the old post permalink slug stored?
- Passing current cookies in wp_remote_get to get Draft Post Preview
- Separate Database Tables For Different Post Types
- MySQL Query to Retrieve Category from wp_posts
- How does WordPress handle MySQL row lock errors?
- Listen to Post action
- Getting wrong relationship value in $args in wp_Query?
- How can I safely increase the character limit for post passwords?
- How to Group Posts by the First Letter or Number?
- Restore contents of deleted user
- How are terms connected with posts in database?
- Manipulate post category after time
- Menu Items disappearing/being empty on save or post edit
- My website is showing today’s date instead of published date since db migration to a new wordpress
- How can I change the date format of the revision list?
- MYSQL: Create SQL query to search for string and replace
- Query to fetch custom taxonomy along with post title
- How to setup default value of post_id
- Mysql update menu_order problem
- Prevent a post with a specific ID from being created
- WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
- WordPress: Develop multiple posts with different data
- Reusing old post IDs
- Trigger on DB make problem on wordpress?
- WordPress MySQL Search and replace with wildcard?
- Comments are in database, don’t show up in WordPress backend or frontend
- Is there a way to save different data when USER interacts with the same POST?
- Add postmeta to all blog posts
- How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
- ‘posts’ table should not store the absolute image path
- Dev and prod on the same database- dev version active for IOS
- load post data into mysql
- 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
- How do I get a certain set of posts from the database?
- Maximum number of posts per page before affecting performance?
- Update user meta when post published no working
- Fixing the WP Post Object for Custom Route
- Surrogate ID for posts, is there an alternative field in the posts table?
- How to filter get_adjacent_post()?
- get backup file from wordpress database in x days
- Expired Post with More Recent Time Stamp?
- Export Posts with specific custom fields by sql
- Custom plugin to get related posts by category
- I moved my site to another server, wp admin works so does the front page, but posts don’t work
- Can’t seem to replicate permalink structure for localhost development site
- Extra field in wp_post instead of postmeta
- Voting System, database connections?
- When I click edit on a post, all the content disappear. Does anyone know how to fix this?
- 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
- FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
- Load posts from external source if not found in database
- How to create a post based on data in a table?
- Hide the contents for specific post
- Is there a maximum amount of pages for a multi-page post?
- How to edit the default database of WordPress [closed]
- If meta_key exists then don’t select this post?
- Error 404 blog/page/2/
- How to make category for word post_content
- Onclick open posts displayed in slider in a popup [closed]
- How can I delete the options from DB when the plugin is deleted?
- What effect can a large wp_post table have on overall site performance?
- How do I save JS classes being applied to the WP dashboard via custom plugin?
- How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
- How can I merge a several related posts into one post?
- Restore posts, but only posts that exist in my database backup
- Change permalinks in posts via SQL
- Is it safe to totally unregister the default “post” Post Type
- How to get a list of all posts and their categories?
- WordPress Post Query Using Custom native MySQL like St_Distance_Sphere
- Can’t save/get Patterns’ `post_content` attribute
- How to extract and reveal code from SQL database in WordPress