Copying a database using phpMyAdmin

1. Load the phpMyAdmin interface via the MySQL databases section in your Control Panel. Detailed information on accessing the phpMyAdmin interface is available in the Accessing phpMyAdmin article.

2. In phpMyAdmin, navigate to the Databases tab and select the database that you wish to copy.

Select a MySQL database

3. Navigate to the Operations tab.

List MySQL tables

4. In the Copy database to field, type the name of the database in which you want to copy the data from the current database. You need to select Structure and data and uncheck the CREATE DATABASE before copying option.

Copying a MySQL database

5. Click on the Go button.