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.

tamlyn

WARNING: This plugin is for advanced users. If used incorrectly it could wipe out all your content!
Keeping databases in sync between development, staging and live servers can be a pain. This plugin lets you 
link together several WordPress installations by sharing a secret token. Once linked, administrators can pull 
or push the entire database between servers with just a click.
Currently syncs database only, not uploaded files.
<h4>Backups</h4>
The plugin will attempt to make local backups of the database before overwriting. These are stored as gzipped SQL 
files in wp-content/plugins/database-sync/backups/dbYYYYMMDD.HHMMSS.sql.gz The backups directory should be made 
writable, and you should keep an eye on it if you sync often as it will grow in size.
<h4>Usage</h4>
See Installation instructions.
<a href="http://outlandish.com" rel="nofollow ugc">Plugin by Outlandish</a>

Database Sync

Is this wizardry?  This plugin works so seemlessly it's amazing!  I love that it pulls the ACF stuff as well which is a huge time saver.  Another issue is the media uploads which this helps with as well.  Simply sync up the two databases and then ftp your uploads and both db's are in perfect lockstep!



WOW!

Sync databases across servers with a single click.

Clone Test DB vs Database Sync