Knowledgebase

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

1. Log in to your cPanel account.
2. Open phpMyAdmin, Click on the phpMyAmin icon:                                                                                                                 
3. The phpMyAdmin administration page will open in a new window. In the left pane, click on the name of the database you want to copy.
4. On the top menu bar, click on Operations.
5. Under "Copy database to," enter the name for the new database in the text box.
6. Choose whether you want to copy both the structure and data or just the structure of the database.
7. Select the "CREATE DATABASE before copying" checkbox.
8. Select the "Add AUTO_INCREMENT value" checkbox.
9. Click on the Go button. phpMyAdmin will create a new database with the specified name and perform the copy operation. Once it finishes, the new database will appear in the list of databases in the left pane.

By following these steps, you can easily copy a MySQL database using phpMyAdmin, regardless of the theme you are using in cPanel.