How to Use PHPMyAdmin to Copy a MySQL Database

This article describes how to copy a MySQL database using phpMyAdmin.

Copying a 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. 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 panel.

  • MySQL, phpmyadmin
  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

Becoming Familiar with Databases in phpMyAdmin

We are going to assume that you are logged in to phpMyAdmin.The main screen is divided into two...

How to Manage MySQL Databases and Users in cPanel

This article describes how to use cPanel to manage MySQL databases and users. You can add,...

How to Access phpMyAdmin in cPanel

This article describes the third-party SQL management tool phpMyAdmin. This web-based database...

How to Configure Remote MySQL Access in CPanel

This article describes how to use cPanel to allow external hosts to access your MySQL databases....

How to Optimize and Repair MySQL Databases using PHPMyAdmin

This article describes how to optimize and repair MySQL databases using phpMyAdmin. Optimizing...

Powered by WHMCompleteSolution