Duplicate a database using phpMyAdmin:

Databases are used to store the WordPress website contents. All WordPress hosting companies are offering MySQL as database management software which is used with command line tools. For beginners, it is not suitable. So there is an option available in Cpanel called phpMyAdmin which is used to manually managing MySQL database. In this tutorial, we will show you how to clone or Duplicate a database by using phpMyAdmin.

Follow the below steps to Clone the database.

Step 1:
Login to your cPanel.

Step 2:
Goto phpMyAdmin under DATABASES section.phpMyAdmin administration page will appear.

Step 3:
Click on the database you want to clone, in the left panel.

Step 4:
Once selected the database, click Operations in the top menu bar.

Step 5:
You can see the Copy Database to box. Enter the new database name for the new duplicate database. Make sure that structure and data boxes are checked.

Step 6:
To create a new database check the box “CREATE DATABASE before copying”.

Step 7:
Also, check “Add AUTO_INCREMENT value” box.

Step 8:
Click on Go button.

Now the database is cloned or duplicated. You can find the new database in the left column. You can see the database inside that new database which is copied from the previous one.

We hope that this article will help you to copy or Duplicate a database using phpMyAdmin. For more information. follow us on Twitter and Facebook. For video tutorials. subscribe to our YouTube channel ServerCake India.

Categorized in:

Tagged in: