SeoPageHost

SeoCms Post Archival System lets you move old posts and custom post types to a separate archive database, keeping your main WordPress database lean and fast.
Key Features:
<ul>
<li>Age-based archival rules — Configure per-post-type rules (e.g., archive posts older than 180 days)</li>
<li>Custom post type support — Works with any registered post type</li>
<li>Full data preservation — Archives posts, post meta, and taxonomy relationships</li>
<li>One-click restore — Restore archived posts back to the main database with all metadata intact</li>
<li>Scheduled archival — Automate archival via WP-Cron (hourly, daily, weekly, or monthly)</li>
<li>Manual batch runs — Run archival on-demand from the dashboard</li>
<li>Archive browser — Search, filter, and browse archived posts from the admin panel</li>
<li>Front-end search — Use the <code>[seocpoar_search]</code> shortcode to let visitors search archived content</li>
<li>Activity logging — Full audit trail of all archive and restore actions</li>
</ul>
How It Works:
<ol>
<li>Configure a second MySQL database in Settings</li>
<li>Set up archival rules per post type with age thresholds</li>
<li>Run archival manually or on a schedule</li>
<li>Archived posts are moved to the separate database with all their metadata</li>
<li>Browse and restore archived posts at any time</li>
</ol>
Shortcode Usage:
Display a searchable archive browser on any page:
<pre><code>[seocpoar_search]
[seocpoar_search per_page="20"]
[seocpoar_search per_page="10" post_type="post"]
</code></pre>

SeoCms Post Archival System

Archive old posts and custom post types to a separate database based on configurable age rules.

boliquan

WP Clean Up can help us to clean up the wordpress database by removing “revision” “draft” “auto draft” “moderated comments” “spam comments” “trash comments” “orphan postmeta” “orphan commentmeta” “orphan relationships” “dashboard transient feed”. 
It allows you to optimize your WordPress database without phpMyAdmin. 
It adds a settings page to “Dashboard”->”Settings”->”WP Clean Up” where you can clean up the wordpress database. 
It allows you to remove the redundant data within few clicks. 
It is a effective tool to keep your database clean and surely save a lot of space of your MySQL Database.
<h4>Usage</h4>
<ol>
<li>Download and extract <code>wp-clean-up.zip</code> to <code>wp-content/plugins/</code></li>
<li>Activate the plugin through the ‘Plugins’ menu in WordPress.</li>
<li>“Dashboard”->”Settings”->”WP Clean Up”</li>
<li>For more information of this plugin, please visit: <a href="http://boliquan.com/wp-clean-up/" title="WP Clean Up" rel="nofollow ugc">Plugin Homepage</a>.</li>
</ol>
Related Links:
<ul>
<li><a href="http://boliquan.com/wp-clean-up/" rel="nofollow ugc">WP Clean Up (FAQ)</a> | <a href="https://wordpress.org/plugins/wp-clean-up/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/wp-smtp/" rel="nofollow ugc">WP SMTP</a> | <a href="https://wordpress.org/plugins/wp-smtp/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/wp-anti-spam/" rel="nofollow ugc">WP Anti Spam</a> | <a href="https://wordpress.org/plugins/wp-anti-spam/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/wp-code-highlight/" rel="nofollow ugc">WP Code Highlight</a> | <a href="https://wordpress.org/plugins/wp-code-highlight/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/wp-slug-translate/" rel="nofollow ugc">WP Slug Translate</a> | <a href="https://wordpress.org/plugins/wp-slug-translate/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/yg-share/" rel="nofollow ugc">YG Share</a> | <a href="https://wordpress.org/plugins/yg-share/" rel="ugc">Download</a></li>
<li><a href="http://boliquan.com/" rel="nofollow ugc">BoLiQuan</a></li>
<li><a href="http://boliquan.com/" rel="nofollow ugc">玻璃泉</a></li>
<li><a href="http://boliquan.com/" rel="nofollow ugc">夜光</a></li>
<li><a href="http://boliquan.com/ylife/" rel="nofollow ugc">YLife</a> | <a href="http://code.google.com/p/ylife/downloads/list" rel="nofollow ugc">Download</a></li>
</ul>

WP Clean Up

WP Clean Up can help us to clean up the wordpress database by removing "revision" "draft" "auto draft" and so on.

SeoCms Post Archival System vs WP Clean Up