How to use phpMyAdmin to copy a MySQL database

This article describes how to copy MySQL database using phpMyAdmin.

Table of Contents

Copying a MySQL database

To copy a MySQL database using phpMyAdmin, follow these steps:

  1. Log in to cPanel.
    If you do not know how to log in to your cPanel account, please see this article.
  2. Open phpMyAdmin:
    • If you are using the Jupiter theme, on the Tools page, in the Databases section, click phpMyAdmin:

      cPanel - Databases - phpMyAdmin icon

    • If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click phpMyAdmin:

      phyMyAdmin

  3. The phpMyAdmin administration page appears in a new window. In the left pane, click the name of the database you want to copy.
  4. On the top menu bar, click Operations.
  5. Under Copy database to, in the text box type the name that you want for the new database.
  6. If you want to copy everything into the new database, select Structure and data. Alternatively, if you only want to copy the database structure, select Structure only, and none of the data will be copied.
  7. Select the CREATE DATABASE before copying check box.
  8. Select the Add AUTO_INCREMENT value check box.
  9. Click Go. phpMyAdmin creates a new database using the name you specified in step 5, and then does the copy operation. When it finishes, the new database appears in the list of databases in the left pane.

Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.

We use cookies to personalize the website for you and to analyze the use of our website. You consent to this by clicking on "I consent" or by continuing your use of this website. Further information about cookies can be found in our Privacy Policy.