Deleted Post Revisions on WordPress and Meta Associated


Sponsored Links






WordPress introduces some new featured that called Post Revisions, if we keep on edit our post content, Post Revision will be created, and this is not good if you have a lot of Post Revision it’s will increased your Databases sizes, on this post I will show you how to deleted post revision and meta associated to those revisions on WordPress. So you can save your Databases sized.

how to deleted post revisions and meta associated

How To deleted post revisions and meta associated

The good things is, we will use SQL Queries to do this, you can use phpMyAdmin or install SQL Executionner Plugin and write down on your SQL Command Area

DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);

And done, you have deleted post revision and meta associated to those revision. Thanks for share this code

Subscribe to Full RSS Feed

RSS FeedIf you thing this article useful, please consider subscribing to our RSS Feed or e-mail updates and stay updated with us. You can also follow @WPTricksNet on twitter for latest updates.

About WP Tricks

We are WordPress Family, we collected and writed useful tips and tricks for you WordPress. We share it for you...

Related Tips and Trick from Local Data and on The Net

How To Delete All WordPress Spam Comments Using phpMyAdmin

I have website that attacker more than 2000 spam each days. And I am so unhappy with it. I know I haven’t installed any Comment Preventing system.  The WordPress spam comment attack is pretty smart because it is definitely automated … Read More

How To Remove Unwanted Meta Boxes

If you made High Custom WordPress and create WordPress not for blog or news website, remove unwanted meta boxes in WordPress is great idea. The Purpose for this idea is created more clean and nice looking also easy to operate … Read More

How To Disable WordPress Post Revision

To save MySQL storage, some WordPress user will be happy using this method, this method is Disable WordPress Post Revision. Why we need disabled this featured? It' because WordPress created such as dummy data revision and this one make our … Read More

Tweak You WordPress Post for better Facebook Share

This code created by Chad Von, a WordPress and Content Management Systems and eCommerce for Business Websites. I live up north in Coeur d'Alene, Idaho. This code is to make your WordPress Post have better view when shared on Facebook. … Read More

Tutorial To Display a Different Number of Post on Search Result

Did you know that, WordPress search result have the same number of post with original WordPress loop, you can check your setting on Settings » Reading » Blog pages show at most. But for some reason, we need to show … Read More

How To Display Total Retweets in Text without Plugin

Twitter become more popular, now every people and website have twitter account. Using twitter there are unlimited abilites, we can share our favorite post, Retweets others tweets and many more. Today WordPress tutorial will share how to Display Total

WordPress tip: Get rid of unused post revisions

Just run the following query on your WordPress database, and all revisions (As well as meta associated with it) will be deleted from your database. read more

Source: http://www.wprecipes.com/wordpress-tip-get-rid-of-unused-post-revisions

How To Disable WordPress Post Revision / WordPress Tricks & Tips

Deleted Post Revisions on WordPress and Meta Associated. WordPress introduces some new featured that called Post Revisions, if we keep on edit our post content, Post read more

Source: http://wptricks.net/how-to-disable-wordpress-post-revision/

how to delete an accoun on cams com - WordPress Tricks & Tips

Deleted Post Revisions on WordPress and Meta Associated WordPress introduces some new featured that called Post Revisions, if we keep on edit our read more

Source: http://wptricks.net/archives/how-to-delete-an-accoun-on-cams-com

Mastering WordPress Post-Revisioning and Auto-Save Features

will nuke all post-revisions and associated meta-data Apparently, WordPress is still saving post revisions behind your autosaved revisions, they may be safely deleted read more

Source: http://digwp.com/2009/07/mastering-wordpress-post-revisioning-and-auto-save-features/

Docs for page post.php - phpdoc.wordpress.org

can be anything, but WordPress post is tied to it is deleted also. This includes comments, post meta fields, and terms associated array wp_get_post_revisions ([int read more

Source: http://phpdoc.wordpress.org/trunk/WordPress/Post/_wp-includes---post.php.html


Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>