SQL query to run via phpmyadmin
DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type="revision"
That query will remove all post revisions from your wp database,, But remember always back up your database before running any direct SQL query..
you can also add a line into wp_config.php that will disable revisions (optional, i use it as i find revisions a bit of a pain)
define('WP_POST_REVISIONS', false);
Related Posts:
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- phpMyAdmin – Error > Incorrect format parameter?
- Get error messages when $wpdb->insert() returns false?
- Does dbDelta delete columns as well?
- Where can I find the database changes between WordPress versions?
- Insert data in database using form
- When is it appropriate to create a new table in the WordPress database?
- Special characters in WordPress UTF-8 [closed]
- how do I determine which image is the featured image in the database
- Split WP install between 2 databases?
- Why does dbDelta() not catch MysqlErrors?
- Accessing two databases
- how to transfer wordpress sql/database from local to live
- Is altering a default WordPress database table update safe?
- what to do when your WordPress database is too large?
- Change all http to https in mysql databse?
- WordPress DB: options-table –> 32 gzipcompression?
- Having issues with wp_postmeta and wp_usermeta tables too big
- How to prevent WordPress from retrieving data for the last 10 posts in the database?
- error establishing a database connection
- Get data from database using $WPDB
- Uppercase to sentence case for post titles
- How to retrieve and show database table in wordpress dashboard
- Moving to another host; which tables to move in a database
- WordPress mysql table double prefixes
- Moving online website to MAMP or dumb idea?
- How can I transition a site from using the Beta Tester plugin to a “normal” install?
- SQL Query to Update Admin Email
- Storing data for a wordpress plugin
- Transient feeds and caching error
- get_tags() return an empty array after added tags with wp_insert_term()
- Is it a bad idea to write audit/access/transaction log information directly to the filesystem?
- WordPress database import: Row size too large
- Advanced SELECT query with condtional statements
- Why do mass updates to post_content shows in front end, but not in edit screen?
- How to disable (get rid of) home page main loop entirely?
- Insert post in another database
- Sync user meta data to a second database
- Redirecting to old domain after migration website
- WordPress Database Huge wp_usermeta Table
- wp-cli search is returning ‘search’ is not a registered subcommand of ‘db’
- Localhost keeps redirecting to live domain
- How to get membershiplevel from WordPress Database?
- cache specific data?
- Child parent relationship inside WP DB
- Copying database tables to new database
- Duplicating Complete WordPress Install for Development and then Redeployment?
- I have a 1300 line excel spreadsheet that needs to get into a wordpress site ASAP – Looking for ideas
- What does wp_term_taxonomy.parent reference?
- How to combine multiple wp_insert_post into one in order to gain better performance
- How to get nav_menu_item_id and slug from wp database
- Two prefixes in database? Which one is valid?
- Enter user registration information in the database
- Problem in using wpdb
- How can I restrict php mail() to only send me one email after a db error
- pull data from a remote wordpress database
- Create database on installation
- How to delete post comments from the database via SQL statement?
- Users table missing from Database [closed]
- Why does changing Database Table Prefixes result in loss of content?
- Options on how to Display member specific data from a MS SQL database
- How to connect and insert data in database of wordpress?
- Unkown meta_value in ACF
- Buddypress avatar image in database [closed]
- wp_option table error while importing
- wp_insert_user not creating account correctly when ID is manually set
- Installing local to live WP into subdirectory
- WordPress SQL – How to Check for Category?
- What is wrong here? Issue with post_id and meta_value
- Getting WordPress to work inside a rails 3 application
- MSQL database wp_postmeta has meta key tve_revision
- Deleting empty meta key values
- Occasional Error Establishing a Database Connection
- WP 5.5, child themes, customizer and a weird cache issue
- Display user data in numbered list
- Removing old_slug and old_date from WordPress Database
- Help with $wpdb on custom code
- “BS_” rows in postmeta table
- How do I change several broken URLs in a several wordpress databases in the fastest way?
- Best way to store 1 billion+ posts?
- Optimize WP site for millions of posts
- What’s the easiest way to connect external database and display data on wordpress?
- Duplicate database to roll back theme & content changes
- Character encoding issue – black diamond question marks on imported post excerpts
- WordPress Migration – Issue with admin panel changes
- mySQL database size large, but tables size less
- Reinstall wordpress/mySQL caused database problem
- How To connect to the same WordPress database with different database user
- How much post meta data is too much?
- I have include wp-config, should I add global $wpdb also?
- Localize strings from db
- Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
- How to have WP Search widget index dynamically generated content?
- Preventing concurrent update of data
- Redirect Issue: WordPress database
- Category not displaying in add post, edit post, and categories page.
- $wpdb->prepare returns empty array
- Prevent creation of unused database tables?
- How to store a plain password in WordPress database in another field
- How to stop WordPress from using utf8mb4_unicode_ci collation