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.

syedamirhussain91

Some times we need to see some values in database and we do not have access the db, in that case we can use this plugin, by installing this plugin you will have access to all tables and you can view all records.
Features:
<ul>
<li>No need to goto cpanel.</li>
<li>No need to install phpmyadmin on the server.</li>
<li>No need to download the database and install it on your local to view the record.</li>
<li>Just Install WP-dbMyadmin.</li>
</ul>

WordPress dbMyadmin

Some times we need to see some values in database and we do not have access the db, in that case we can use this plugin, by installing this plugin you …

Clone Test DB vs WordPress dbMyadmin