How to Copy a Database in phpMyAdmin

Learn how to copy or duplicate a database using phpMyAdmin through a simple, built-in process. This includes accessing phpMyAdmin from your hosting control panel and using the Operations tab to create a new database with the same structure and data as an existing one. Duplicating a database can be useful for backups, testing changes, or safely making updates without impacting your original data.

1. Log in to your Customer Portal.
2. Go to Websites from the left navigation menu.
3. Click Settings next to the website you want to manage.

   

4. On the Website Overview page, under the Quick Links section, click the phpMyAdmin button.

   

5. After clicking phpMyAdmin, you will be redirected to your phpMyAdmin home page.

   

   Alternatively, you can access phpMyAdmin using the following guides based on your hosting control panel:

   • cPanel
     How to Access phpMyAdmin from cPanel

   • Plesk
     How to Manage Databases With the Webadmin - Plesk

6. In phpMyAdmin, click the database you want to copy.

   

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

   

8. Scroll down to the section labeled Copy database to.
9. Type in the name of the new database.

   

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

    

15. You will notice your new database listed in the left column. If you go inside, you will see that 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