How To Copy Or Duplicate An Existing Database With phpMyAdmin?

For testing the modifications made to your website or for any other comparable purpose, you may need to copy or duplicate an existing database. You can use phpMyAdmin to clone or duplicate an existing database without damaging your website by following the instructions in this tutorial:

• Login to your cPanel control panel.
• Navigate to phpMyAdmin.

• When you click on phpMyAdmin, a list of databases will be displayed on the left hand side, select the database that you wish to copy.

• Click on ‘Operations’ present on the top menu and a list of all the possible actions that can be done with the database will be displayed.

• Look for an option that says ‘Copy database to:’ and in the text field enter the name of the new database.
• Click on ‘Go’ and the database copying process will start.

Your freshly created database will show up in the list of databases in phpMyAdmin as well as under “MySQL Databases” in your web hosting control panel.