gerrygooner

<p>This WordPress plugin will cleanup your WordPress database, performing the following actions:</p>
<ul>
<li>Remove all post revisions.</li>
<li>Remove all spam comments.</li>
<li>Remove all unapproved comments.</li>
<li>Remove all unused tags.</li>
<li>Remove all unused post meta.</li>
<li>Optimize MySQL tables by removing all unused table space.</li>
</ul>
<p>Based on WP-Cleanup by JortK, this plugin replaces usage of mysql_query() that was deprecated in PHP 5.5 with WP_Query functions .</p>


WP-CleanDB

opicron

<p>Did you ever scale or crop uploaded images in wordpress? Did you ever try various image generating plugins? Did you ever change or add various media image sizes? If yes, chances are that your content folder is full of unused and unreferenced images. These image leftovers will remain cluttering your content folder until the end of days.</p>
<p>Image Cleanup will index these (and many more) unreferenced images. Unreferenced images are not indexed in the wordpress database and also not used by posts, scripts or backup restore meta data. Please note that images which have valid database metadata but are not used in posts are not indexed at this time. This is beyond the scope of this plugin.</p>
<p>Image Cleanup will also find images without meta data and images with incorrect meta data.</p>
<ul>
<li>Save space taken up by unreferenced/backup images!</li>
<li>Fix incorrect metadata (sizes)</li>
<li>Bulk repair/delete functionality</li>
<li>Pagination for extremely large result sets</li>
<li>Logs tabs easily visible for reviewing!</li>
<li>Detailed information in log tabs!</li>
<li>Full restore functionality!</li>
<li>Especially useful for developers!</li>
<li>Written as class to avoid any conflicts!</li>
<li>Highly configurable to avoid memory and/or timeouts on some setups</li>
</ul>
<p><em>On my one month old website with 50 files (and 250 attachment size variants) this plugin found 95 unreferenced images which I could remove without any conflicts.</em></p>
<p><em>There has been a reported case where this plugin indexed and removed over 23.000 images on a website. See forum/review for details</em></p>
<h4>Image Cleanup workflow details</h4>
<ul>
<li>Retrieves all attachment images from the database (including size variants);</li>
<li>Finds all images in the wp-content folder;</li>
<li>Subtracts the attachment (and size variants) from physical found images;</li>
</ul>
<p>The above will result in an list of invalid images which are not referenced by the database</p>
<ul>
<li>Posts will be searched for images and found images will be subtracted from the invalid files (if any);</li>
<li>Scripts in wp-content will be searched for images and they will be subtracted from the invalid files (if any);</li>
<li>Backup images (for restoring images after scale/crop) will be subtracted from the invalid images;</li>
<li>Found unreferenced files will be checked against the meta data to see if the database meta entry still exist;</li>
</ul>
<p>This results in various image lists in which the images can be reviewed, repaired or removed.</p>
<h4>After indexing</h4>
<p>After indexing you are able to (temporary) move the images to a backup folder to check the site without the images in the wp-content folder. You could also check the logs in the ../wp-content/uploads/image-cleanup/ID/logs folder for full information about the index.</p>
<p>If any problems are found you can revert the move of images by restoring them to their original locations.</p>
<p>When no problems arrise after moving the images to another location it is possible to permanently remove the images.</p>
<h4>Future planned additions</h4>
<ul>
<li>Index unused valid images </li>
<li>Index missing image sizes (and option to generate missing images)</li>
<li>Index missing images which are used in posts</li>
</ul>


Image Cleanup

Image Cleanup will index unreferenced images. These can be leftovers from cropping and scaling images. Stop them cluttering your content folder!

WP-CleanDB vs Image Cleanup