How to use phpMyAdmin to copy a MySQL database

This article provides instructions on duplicating a MySQL database using phpMyAdmin.

Copy MySQL database

Please, follow these steps to copy a MySQL database using phpMyAdmin:

1. Log in to cPanel.
2. Click phpMyAdmin in the DATABASES section of the cPanel home screen:                                                                                                                                                               The phpMyAdmin administration page appears in a new window.
3. Click the name of the database you want to copy in the left pane.
4. Click Operations on the top menu bar.
5. Type the name that you want for the new database in the text box under Copy database.
6. Select Structure and Data if you want to copy everything into the new database.  In case you wish to duplicate only the database’s structure, opt for the “Structure only” option, and no data will be replicated.
7. Before copying the check box select the CREATE DATABASE.
8. Select the Add AUTO_INCREMENT value check box.
9. Click Go, and phpMyAdmin creates a new database using the name you specified in step 5, after that does the copy operation. Once the process is complete, the newly created database will be visible within the list of databases located in the left panel.

Looking for an outstanding cPanel-based web hosting provider? Try our web hosting packages with cPanel