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.

Lester Chan

This plugin cleans up:
<ul>
<li>Revisions</li>
<li>Auto drafts</li>
<li>Deleted comments</li>
<li>Unapproved comments</li>
<li>Spammed comments</li>
<li>Deleted comments</li>
<li>Orphaned post meta</li>
<li>Orphaned comment meta</li>
<li>Orphaned user meta</li>
<li>Orphaned term meta</li>
<li>Orphan term relationships</li>
<li>Unused terms</li>
<li>Duplicated post meta</li>
<li>Duplicated comment meta</li>
<li>Duplicated user meta</li>
<li>Duplicated term meta</li>
<li>Transient options</li>
<li>Optimizes database tables</li>
<li>oEmbed caches in post meta</li>
</ul>
This plugin uses proper WordPress delete functions as much as possible instead of running direct delete MySQL queries.
Following delete functions are used:
<ul>
<li>wp_delete_post_revision()</li>
<li>wp_delete_post()</li>
<li>wp_delete_comment()</li>
<li>delete_post_meta()</li>
<li>delete_comment_meta()</li>
<li>delete_user_meta()</li>
<li>delete_term_meta()</li>
<li>wp_remove_object_terms()</li>
<li>wp_delete_term()</li>
<li>delete_transient()</li>
<li>delete_site_transient()</li>
</ul>
WP-Sweep WP REST API Endpoints 
* <code>GET /wp-json/sweep/v1/count/<Name></code>. Get the number of items that we will be sweeping. 
* <code>GET /wp-json/sweep/v1/details/<Name></code>. Get the details of the items that we will be sweeping. 
* <code>DELETE /wp-json/sweep/v1/sweep/<Name></code>. Runs sweep for that particular item.
WP-Sweep WP-CLI Commands 
* <code>wp sweep --all</code>. Runs sweep for all items. 
* <code>wp sweep <Name></code>. Runs sweep for that particular item. 
* <code>wp sweep <Name1> <Name2></code>. Run sweep for the selected items.
WP-Sweep Available Items: 
* revisions 
* auto_drafts 
* deleted_posts 
* unapproved_comments 
* spam_comments 
* deleted_comments 
* transient_options 
* orphan_postmeta 
* orphan_commentmeta 
* orphan_usermeta 
* orphan_termmeta 
* orphan_term_relationships 
* unused_terms 
* duplicated_postmeta 
* duplicated_commentmeta 
* duplicated_usermeta 
* duplicated_termmeta 
* optimize_database 
* oembed_postmeta
WP-Sweep is not compatible with the following plugins: 
* <a href="https://wordpress.org/plugins/custom-fonts/" rel="ugc">Custom Fonts</a> 
* <a href="https://elementor.com/features/popup-builder/" rel="nofollow ugc">Elementor Popup Builder</a> 
* <a href="https://wordpress.org/plugins/mailpress/" rel="ugc">MailPress</a> 
* <a href="https://wordpress.org/support/plugin/ml-slider/" rel="ugc">Meta Slider</a> 
* <a href="https://wordpress.org/plugins/polylang/" rel="ugc">Polylang</a> 
* <a href="https://revolution.themepunch.com/" rel="nofollow ugc">Slider Revolution</a> 
* <a href="https://codecanyon.net/item/viba-portfolio-wordpress-plugin/9561599" rel="nofollow ugc">Viba Portfolio</a> 
* <a href="https://wpml.org/" rel="nofollow ugc">WPML</a>
<h3>Build Status</h3>
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a> 
<a href="https://codeclimate.com/github/lesterchan/wp-sweep" rel="nofollow ugc"></a>
<h3>Development</h3>
<ul>
<li><a href="https://github.com/lesterchan/wp-sweep" title="https://github.com/lesterchan/wp-sweep" rel="nofollow ugc">https://github.com/lesterchan/wp-sweep</a></li>
</ul>
<h3>Credits</h3>
<ul>
<li>Plugin icon by <a href="http://www.freepik.com" rel="nofollow ugc">Freepik</a> from <a href="http://www.flaticon.com" rel="nofollow ugc">Flaticon</a></li>
</ul>
<h3>Donations</h3>
I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.

WP-Sweep


WP-Sweep is a simple yet powerful plugin that helps keep your WordPress site running smoothly. It cleans up unnecessary data like post revisions, trashed posts, spam comments, unused terms, and more — all using native WordPress functions, which makes it safer than many alternatives.



We've used WP-Sweep on multiple websites and it's never caused any issues. It's lightweight, user-friendly, and does exactly what it promises. The interface is clear and makes it easy to choose what to clean.



Highly recommended for anyone looking to optimize their WordPress database without the risk of breaking anything.


Great plugin to keep your WordPress database clean and optimized

Thanks a lot

WP-Sweep allows you to clean up unused, orphaned and duplicated data in your WordPress. It also optimizes your database tables.

SeoCms Post Archival System vs WP-Sweep