One of the irritating feature for me in WordPress 2.6 is the post revision. I am the only author of my blog and hence this feature is useless to me.<\/p>\n
Just in case you are wondering how post revision works, whenever a post is edited, a new row<\/strong> will be created in wp_posts table. Hence if your posts or pages got edited 10 times, you will have 10 new rows in wp_posts table.<\/p>\n In no time<\/strong> your wp_posts table will be filled up and the post ID will be huge.<\/p>\n To turn off this feature, add this following code to wp-config.php<\/strong>:<\/p>\n Be sure to backup your database first before performing any queries in phpMyAdmin.<\/p>\n *UPDATE* Auto Saves does not create a revision of the post.<\/p>\n *UPDATE 2* Updated SQL query from Andrei Neculau<\/a> as the previous query does not delete from wp_postmeta and wp_term_relationships tables.<\/p>\n *UPDATE 3* There is a proper way of cleaning up Post Revisions as mentioned by kitchin in Deleting Post Revisions: do NOT use the a,b,c JOIN code you see everywhere<\/a>. I like his method more than the SQL query above.<\/p>\n","protected":false},"excerpt":{"rendered":" One of the irritating feature for me in WordPress 2.6 is the post revision. I am the only author of my blog and hence this feature is useless to me. Just in case you are wondering how post revision works, whenever a post is edited, a new row will be created in wp_posts table. Hence … Continue reading “How To Turn Off Post Revision In WordPress 2.6”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[88,87,86],"class_list":["post-188","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-disable","tag-off","tag-revision"],"views":138642,"_links":{"self":[{"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/posts\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/comments?post=188"}],"version-history":[{"count":0,"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/posts\/188\/revisions"}],"wp:attachment":[{"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/media?parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/categories?post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lesterchan.net\/wordpress\/wp-json\/wp\/v2\/tags?post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\r\ndefine('WP_POST_REVISIONS', false);\r\n<\/pre>\nYou can also delete all post revisions by running this query in phpMyAdmin:<\/del><\/p>\n\r\nDELETE a,b,c \r\nFROM wp_posts a \r\nLEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) \r\nLEFT JOIN wp_postmeta c ON (a.ID = c.post_id) \r\nWHERE a.post_type = 'revision' \r\n<\/pre>\n