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.

Utkarsh

Mehul Kaklotar

littlemonks

A wordpress cleaner plugin to help find and remove orphan, duplicate and missing data.
<h4>Contributing to WP DB Cleaner</h4>
If you have a patch, or stumbled upon an issue with WP DB Cleaner, you can contribute this back to the code. Submit your pull request or issue on <a href="https://github.com/mehulkaklotar/wp-db-cleaner" rel="nofollow ugc">Github wp-db-cleaner</a>

WP DB Cleaner

A wordpress cleaner plugin to help find and remove orphan, duplicate and missing data.

Clone Test DB vs WP DB Cleaner