How to Copy a Database in phpMyAdmin

To copy or duplicate a database in phpMyAdmin.

1. Log in to cPanel. There are two ways to access your cPanel.
   • Option 1: Access your cPanel directly.
   • Option 2: Access your cPanel via your Customer Portal.
     1. Log in to your Customer Portal.
     2. Click Hosting in the left-side menu.

        

     3. If you have a single hosting package in your account, scroll down to the Quick Links section.

        
        If you have multiple hosting packages in your account, locate the hosting package you want to manage on the Hosting Packages page, then click its Manage button.

        

     4. Under the Quick Links section, click the cPanel button.

        

2. Within cPanel, go to the Databases section, then click phpMyadmin.

   

3. Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).

   

4. Once inside the database, select the Operations tab.

   

5. Scroll down to the section where it says Copy database to.
6. Type in the name of the new database.

   

7. Select structure and data to copy everything.  Alternatively, you can select Structure only if you want the columns but not the data.
8. Check the box CREATE DATABASE before copying to create a new database.
9. Check the box Add AUTO_INCREMENT value.
10. Click on the Go button to proceed.
11. Click on the Home icon.

    

12. You will notice your new database listed in the left column. If you go inside, you will see the database is a copy of the previous database.

    

Related Articles

• How to Access phpMyAdmin from cPanel
• How to Create or Delete a MySQL Database or User
• phpMyAdmin