How to use phpMyAdmin to copy a MySQL database

Last modified: Tuesday November 28th, 2023
In this article

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:                    How to use phpMyAdmin to copy a MySQL database kb cpanel 78 databases phpmyadmin icon                                                                                                                                           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

Was this article helpful?
Views: 187

10 Years Beehosting!
Celebrate with 70% OFF + FREE Site Transfer. website uses cookies

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.