=== Plugin Name === Contributors: Rolf van Gelder Donate link: http://cagewebdev.com Plugin Name: Optimize Database after Deleting Revisions Plugin URI: http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin Tags: wp, database, delete, revisions, optimize, posts, pages, clean up, trash, spam, trashed, spammed Author URI: http://cagewebdev.com Author: Rolf van Gelder, Eindhoven, The Netherlands Requires at least: 2.0 Tested up to: 3.4.2 Stable tag: 1.2 Version: 1.2 == Description ==
This plugin is a 'one click' database optimizer.
It deletes the redundant revisions of posts and pages, trashed items and/or spammed items and, after that, optimizes all database tables.
http://cagewebdev.com/index.php/optimize-database-after-deleting-revisions-wordpress-plugin
Author: Rolf van Gelder, Eindhoven, The Netherlands - http://cagewebdev.com
== Installation ==1.0 11/22/2011 Initial release
1.0.1 11/24/2011 A few updates for the readme.txt file
1.0.2 12/02/2011 Some minor updates
1.0.3 12/15/2011 Some minor layout updates
1.0.4 06/06/2012 Now also works with non short_open_tag's
1.0.5 08/21/2012 Depreciated item ('has_cap') replaced, abandoned line of code removed
1.1 08/29/2012 Added: a new option page, in de plugins section, where you can define the maximum number of - most recent - revisions you want to keep per post or page
1.1.2 08/30/2012 Minor bug fix for the new option page
1.1.3 09/01/2012 Moved the 'Optimize DB Options' item to Dashboard 'Settings' Menu and the 'Optimize Database' item to the Dashboard 'Tools' Menu. That makes more sense!
1.1.4 09/01/2012 Something went wrong deploying 1.1.3, so I deployed it again as 1.1.4
1.1.5 09/01/2012 Something went wrong deploying 1.1.4, so I deployed it again as 1.1.5. *sigh*
1.1.6 09/01/2012 Fixed the link to the options page
1.1.7 09/03/2012 Some textual and link fixes
1.1.8 09/08/2012 Another link fix
1.1.9 09/27/2012 Using a different method for retrieving database table names
1.2 10/03/2012 Major update: new options 'delete trash', 'delete spam', 'only optimize WordPress tables'
== Frequently Asked Questions ==Q: How can I change the settings of this plugin?
A: In the WordPress Dashboard go to 'Settings / Optimize DB Options'. There you can define the maximum number of - most recent - revisions you want to keep per post or page.
Q: How do I run this plugin?
A: In the WordPress Dashboard go to 'Tools'. Click on 'Optimize Database'. Et voila!
Q: Why do I see 'Table does not support optimize, doing recreate + analyze instead' while optimizing my database?
A: That is because the table type of that table is not 'MyISAM'