Yuya Hoshino

How it works:
<ol>
<li>
Click ‘Tools > Clone Test DB’.
</li>
<li>
Enter the ‘Test site address’.
</li>
<li>
Select ‘Test database name’.
</li>
<li>
Click ‘Create a clone site’.
</li>
</ol>
<ul>
<li>To view the test site, you will need to transfer files.</li>
<li>Sorry, multi-site is not supported.</li>
</ul>

Clone Test DB

It's a five star plugin just because it works as advertised, and it's easy to use it even though it has it's limitations, and you have to take a couple if (easy) steps.

1. Before cloning the database, edit the target folder's wp-config.php file, and change the database name to the target one (new installation's database). This is the code define( 'DB_NAME', "YOUR_DATABASE_NSME_HERE" );

2. After you clone the database, and if the cloned site is displaying a 404 (page not found) on the posts, pages, cpt, then log in to the backsite, and flash (update) the permalinks, this will solve the 404 errors.

Ok now the limitation: There is only one, and it is the fact that both websites HAVE to be on the same server, you cannot have a localhost -> live situation or vice versa for example, I hope the ability to log in into external databases will be added soon.



It's getting the job done.

Duplicate the table in another database and optimize it as a test site.

Jordy Meow

Database Cleaner is packed with features to handle big databases, built from years of experience with similar plugins. It works great with the latest WP and PHP versions and has an easy-to-use interface. For large tasks, it uses asynchronous requests to avoid errors and timeouts, ensuring smooth processing. Check it out at <a href="https://meowapps.com/database-cleaner/" rel="nofollow ugc">Database Cleaner</a>.
IMPORTANT: Always back up your data before using this or any plugin! While Database Cleaner is reliable, it’s always best to be safe. Better safe than sorry! 🙂
<h3>Features</h3>
<ul>
<li>Easy Mode & Expert Mode: Whether you’re a beginner or a pro, there’s a mode for you. Easy mode simplifies everything, while Expert mode gives you full control.</li>
<li>One-Click Cleaning: Save time with automatic cleaning. Just one click, and your database is tidy and optimized.</li>
<li>Smart Data Management: Understand how plugins or themes use your data. The Pro Version offers even deeper insights.</li>
<li>Detailed Statistics: Keep an eye on your database size with comprehensive stats and history tracking.</li>
<li>Effortless Data Browsing: Explore and categorize your data with ease. Find what you need without any hassle.</li>
<li>Big Database Handling: Perfect for large databases, it uses smooth, error-free asynchronous requests to manage heavy tasks.</li>
<li>In-Depth Analysis: Specialized tools to analyze and monitor your data across Post Types, Tables, Options, and Cron Jobs.</li>
</ul>
<h3>Why another Database Cleaner?</h3>
While other database cleaners are available, my experience with them revealed areas for improvement, like outdated UIs, incomplete features, and limited data analysis capabilities. Most notably, they struggled with large databases. Motivated by these challenges, I developed my own solution. Now, I’m dedicated to refining it to suit all types of WordPress and databases, aiming to make it the best for everyone.
I’m open to feedback and would be thrilled to discuss how Database Cleaner can better meet your needs. Let’s chat and enhance this tool together!

Database Cleaner


for now, I can tell It works better than any other database-optimizing plugin.


‌Best plugin for database cleaning


Now THIS guy really knows what he's doing. Fantastic UI for "Easy" and "Expert". As an expert I can easily delete loads of crud from the DB, and if I'm not sure I can even look at the value of a DB entry to find out more about it. Simply perfect. And that's all in the free version! I also recommend Jordy's companion plugin Media Cleaner highly - if you want to clean orphaned files in uploads you need the Pro version - I paid for it gladly.


Features you didn't dare dream of

Worth 5 stars without a doubt.  Efficient with an easy mode as well as an expert mode that gives you a lot of possibilities.

Haven't explored the hooks provided such as for example batch assigning unknown metas/options to plugins, but overall am happy with what I saw especially compared to other db clearner plugins out there which give you very basic cleaning functionality while all the real cleaning power site behind the paid version.

Lots of cleaning power


Your plugin is much too good, the interface is super well-thought-out. It's very easy to use, and allows going very far in cleaning up databases. Keep up the good work! You rock!


Deserves more installations

User-friendly tool to clean and optimize databases. Efficiently manages large databases, simplifying repair and ensuring peak performance.

Clone Test DB vs Database Cleaner