DECEMBER 8, 2017 6 MINS READ
Duplicating a WordPress database comes handy when you are migrating a WordPress website. There are many plugins to help you clone the entire WordPress website. When you are backup and restoring the website the plugins will be handy.
When you are in the middle of restoring the website or transferring the website, you might have to clone your WordPress website database manually. Duplicating WordPress database via the phpMyAdmin is the best way and also the easiest way you can use to duplicate the database.
Duplicate WordPress Database in Shared Hosting
In shared hosting, you have to duplicate or clone your WordPress database manually. Some of the hosting providers may give you the option to duplicate the database directly, which we will see next. Now, let us see how to duplicate WordPress database manually using phpMyAdmin.
Login to your cPanel and find the database option. In that select the phpMyAdmin.
After it, you will be taken to your WordPress website database. Here you will find all the site database. Select the database you want to duplicate. Then you have export the database you want to duplicate. Click the export tab at the top.
The export tab will look like in the above image. Now scroll down to the output section and select the ‘Save output to a file’ option. The selected database will be exported to your local computer in the MySQL format.
Create New Database
Now you have to create a new database to save the exported database copy. For that, you have to again login to your cPanel and select the MySQL databases. In that select the option to create a new database.
On the next screen, you will be shown the option to give a name to the new database as shown above. Give a name to the new database and click create a new database. Now you have to add a user to the new database, for that you have to scroll down to the ‘Add user to database’ section.
In the following screen, select the user and the newly created database. Add the user to the newly created database. Now the database is created and readily handle your exported database copy.
To add the exported copy to the database, go to the cPanel. Select the phpMyAdmin option and in that select the newly created database. In that, you have the “Import” options tab at the top.
In that, you have to select the database copy you have exported to your local computer. Select the MySQL format database copy file and click “Go” button. After completing the import, you will get a success message.
[experts_box experts_title=”Easy One Click Solution:”]The optimized website always performs better than other sites. Get the WordPress Optimization support service.[/experts_box]
Using The Copy Database Option
As said before some of the server providers give you the option to copy the database directly. For that login to your cPanel and select the phpMyAdmin option. In the phpMyAdmin select the database you have to copy as told in the above process.
Here inside the database, you will see an option “operation” along with the import and export option at the top. Select the operation option; you will get a screen like below
In the Copy database to option you have to give your new database name. Make sure the “Structure and data” option is selected and click the Go button. The phpMyAdmin will automatically create a new database and copy the selected database to the new the database created.
Plugins To Duplicate WordPress Database
You have plugins to help you duplicate a database. All you have to do is to install the plugin to the WordPress and select the database to duplicate and to select where to put the duplicate copy. Rest will be taken care by the plugin itself.
WP Database Backup
WP Database Backup plugin helps you to create Database Backup and Restore Database Backup easily on a single click. You have the option to save the backup to Google Drive, Dropbox and Amazon S3
- Scheduled Auto Backup
- Restore Database Backup
- Multiple storage destinations
- Sort database backup list and also have the option to search
WP Migrate DB
WP Migrate DB does the export job for you. As we have done in the manual method, this plugin will export your database file as a MySQL format. Then you have manually restored the database copy using the import option from the phpMyAdmin. There is also a pro version of this plugin with advanced options.
- Save migration profiles
- In-place find & replace
- Pause and cancel migrations
- Export your database
- Find & replace that handles serialized data
All-in-One WP Migration
All in one WP Migration plugin exports almost everything from your site. You can export database, media files, plugins, and themes all in one click.
- Can operate on any operating systems and hosting
- No upload file size restriction, since it uses chunks to import site data.
- It supports both MySQl and MySQLI
- Set multiple destinations like Google drive, one drive, and Dropbox
Duplicator is one of the famous database clone plugins. It has over one million active installs and also updated periodically. You can migrate, copy, move or clone a site from one location to another easily with this plugin.
- Move, migrate or clone a WordPress site between domains or hosts with zero downtime
- Pull down a live site to localhost for development
- Manually backup a WordPress site or parts of a site
- Duplicate a live site to a staging area or vice versa
- Bundle up an entire WordPress site for easy reuse or distribution
- Perform a full WordPress migration without struggling with messy import/export SQL scripts
WP DB manager helps you to maintain the database effectively. It allows you to repair database, backup database, restore the database, delete backup database, drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.
Ready to Clone Your WordPress Site?
These are the common methods you use to clone your WordPress site. This may come in handy when you are migrating your website or manually backup your site. Most of these works are nowadays taken care by the WordPress plugins. If you are a beginner it is better to use the plugin.