> ## Documentation Index
> Fetch the complete documentation index at: https://kb.hosting.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Using phpMyAdmin to copy a MySQL database

> Copy a MySQL database using phpMyAdmin with our step-by-step guide and explore related articles.

This article describes how to copy MySQL database using phpMyAdmin.

## Copying a MySQL database

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

1. Log in to cPanel.
   > 📘 Note
   >
   > If you do not know how to log in to your cPanel account, please see [this article](/docs/accessing-cpanel).

2. On the **Tools** page, in the **Databases** section, click **phpMyAdmin**:\
   ![cPanel - Databases - phpMyAdmin icon](https://static.hosting.com/kb/kb-cpanel-jupiter-phpmyadmin-icon.png)

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.

## Related articles

* [Accessing phpMyAdmin and phpPgAdmin](/docs/phpmyadmin-and-phppgadmin)

* [Optimizing and repairing MySQL databases with phpMyAdmin](/docs/optimizing-and-repairing-mysql-databases-with-phpmyadmin)

* [Managing MySQL databases, users, and tables from the command line](/docs/managing-mysql-databases-and-users-from-the-command-line)