How To Copy a MySQL Database Using phpMyAdmin

In this article, we will describe how to copy a MySQL database with the help of phpMyAdmin.

Follow these steps to copy a MySQL database using phpMyAdmin:

1. Log into your “cPanel Account”.
   
   
2. From the Search Tool, click on “phpMyAdmin”.
   
3. In the left side, select the database you want to copy by clicking on its name.
   
4. Click on “Operations”.
   
5. Enter the name you want for the new database in the text box under “Copy database to”.
   
6. Select any one of them.
   1. Choose Structure and data to copy everything to the new database.
   2. Alternatively, you can choose Structure only to duplicate the database structure alone.
   3. Exclude the data from the copy.
      
7. Tick mark the “CREATE DATABASE before copying” check box.
8. Tick mark the “Add DROP TABLE.DROP VIEW” check box.
9. Click on “GO”.
   

That’s it!! you are done.

In this article we have seen how to copy MySQL database using phpMyAdmin. If you’re interested in learning how to backup a MySQL database using cPanel, check out our comprehensive guide on How to Backup a MySQL Database using cPanel. This method provides an alternative way to protect your database data.

Was this article helpful to you? If you continue having problems with the above outlined article, please contact the WHUK team.