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.
3. Navigate to the Operations tab.
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.
5. Click on the Go button.