How to use phpMyAdmin to copy a MySQL database

Last modified: Wednesday June 22nd, 2022
In this article


This article describes how to copy MySQL database using phpMyAdmin.

Copy MySQL database

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

  1. Log in to cPanel.
  2. In the DATABASES section of the cPanel home screen, click phpMyAdmin:                  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. 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.

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

Was this article helpful?
Views: 90
Sidebar

Beehosting.pro 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.

Menu