Stop WordPress post’s revisions
There is a new feature in WordPress version 2.6 and above which will store the post’s revision into database. I don’t really want to use it and decided to disable this new feature.
To clear the existing post’s revision in database, run the following SQL statement in your database environment:
Delete from wp_posts where post_type=’revision’;
For disabling the revision, I found that there is suggestion to add the following code to disable the revision but not including automatic save:
define(’WP_POST_REVISIONS’, false);
However, I found that it is not working on all my websites; revision is still generated when I update the post.
At last, I found the following plug-in from HostScope which do the job correctly.
The No Revisions WordPress Plugin