How to Delete Existing WordPress Post Revisions Stored/Saved
For users who had disabled or turned off post revisions tracking or versions history feature in WordPress (added since WordPress 2.6), it is also made sense to delete and remove all existing stored post revisions and changes made on pages stored in the database in order to reduce the wp_posts table size, especially when there is already tons of revisions or changes been kept.
To delete and remove all existing post revisions entries and rows from WordPress database Posts table, simply login to MySQL command-line interface, phpMyAdmin, SQLyog or other MySQL GUI tools. Select the appropriate WordPress database (if you have more than one databases on the same server), and then issue the following command (it’s also recommended to backup the database before performing the deletion SQL statements):
DELETE FROM wp_posts WHERE post_type = "revision";
Once all post revisions related records is purged, all revision histories is deleted, and users no longer able to check the changes by phase or compare differences between versions. Thus, deletion may also been used by administrator to ensure privacy or stop authors or writers in the blog from knowing their posts have been edited.
Share and contribute or get technical support and help at My Digital Life Forums.
Related Articles
- Disable and Turn Off Post Revisions Tracking in WordPress 2.6 or Above
- How To Store Every Post Revisions on Each Auto-Save in WordPress with Limit on Versions Count
- Paginating or Split WordPress Post or Page with NextPage in WordPress Not Working
- Manage Tags in WordPress 2.3 with Advanced Tag Entry and Click Tags Plugins
- Adding Extra More Fields to WordPress Write/Edit Post/Page Right Column
- Retrieve and Get WordPress Post ID Outside the Loop as PHP Variable
- How to Change the Frequency or Interval WordPress Auto Saves An Editing Post or Page
- Disable Auto Go To (Jump) To Read More Tag
- WordPress 2.6 with Change Revision Tracking Feature Available for Free Download
- 3 Column Relaxation WordPress Theme comments-paged.php for Paged-Comments WordPress Plugin
Entries (RSS)
July 23rd, 2008 04:25
[...] and Turn Off Post Revisions Tracking in WordPress 2.6 or AboveHow to Delete Existing WordPress Post Revisions Stored/Saved Ctrl-z [↩]Post Revision 資料是寫入 wp_posts 資料表 [...]
July 25th, 2008 03:51
[...] what about those revisions left in your database? Several posts look as if they found the true answer, but it’s one of those “The one who laughs last, [...]
August 17th, 2008 17:39
[...] How to Delete Existing WordPress Post Revisions Stored/Saved shows how you remove existing revision posts from your database. This entry was written by Bengt, posted on August 17, 2008 at 9:39 am, filed under Blogging and tagged WordPress. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL. Written by Bengt and published on August 17, 2008 Posted in: Blogging Tagged with: WordPress If you liked this - share it! StumbleUpon | Digg it | del.icio.us | Email this Subscribe: by RSS or email « Authentic blogging [...]
September 3rd, 2008 06:55
[...] beschränkt. Das Löschen alter Versionen ist auch nur schwer möglich über einen SQL-Befehl, der hier erklärt wird. Scheint aber auch nicht immer zu funktionieren. Eventuell hilft dieses Plugin [...]