How to Duplicate a MySQL Database in cPanel

If you need to duplicate or copy an existing cPanel MySQL database to new, this can be done using phpMyAdmin by following the steps below:

Note: It’s important that you BACKUP your database first before performing the steps below.

1. Login to your cPanel Account
2. Create a new Database with the cPanel MySql Wizard
3. Select the phpMyAdmin icon
4. Select the database you wish to copy from the list in the left-hand sidebar
5. Select the Operations tab
6. Scroll down to Copy database to
7. Enter the new database name using the Cpanel name format (with the username_ prefixed)  and select structure and data to copy everything.
8. Check the box Add AUTO_INCREMENT value
9. Click on the Go button to proceed

You should now see your duplicated database in the list within the left-hand sidebar.