To duplicate the database follow these steps:
1. Log into cPanel >> Databases section >> phpMyAdmin menu.
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_1.png)
2. Select the database from the list on the left and click the Operations option from the top bar:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_2.png)
3. On the next step, you need to specify a name for the new duplicate database in the Copy database to field.
Make sure the following options are selected:
'Structure and Data'
'CREATE DATABASE before copying'
'Add AUTO_INCREMENT value'
and then click the Go button:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_3.png)
4. Once the process is completed, you will see a message and the new database will appear in the list of the databases on the left side:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_4.png)
It’s also possible to copy the database manually. You need to follow these steps:
1. Log into cPanel > Databases section > MySQL Databases menu:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_5.png)
2. Create a new database following this article. We will use “nctests_wp952_copy2” database as the newly created one.
3. Once the database is created, navigate to phpMyAdmin menu:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_1.png)
4. Choose the database that you need to copy. (to select the tables, checkmark Check All under the tables) > click Export option from the top bar:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_6.2.png)
5. Select Export Method: Quick and Format: SQL
Click Go:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_7.png)
The selected database will be saved to your computer.
6. After that, select the newly created database from the left side of phpMyAdmin and click Import from the top bar:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_8.png)
7. Select the exported sql file from your computer using the Browse button and then click the Go button:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_9.png)
8. Once done, you will see a notification that your database was successfully imported and all the tables will appear in the new database:
![](https://Namecheap.simplekb.com/SiteContents/2-7C22D5236A4543EB827F3BD8936E153E/media/WP_DB_duplicate_10.png)
NOTE: Maximum size of the database that can be imported in phpMyAdmin is 50MB. Larger databases have to be imported/exported via SSH.
That's it!