Follow the next steps to duplicate the database:
1. Log into cPanel >Go to Databases section > phpMyAdmin menu:
2. From the list on the left choose the database and click the Operations option from the top bar:
3. In the Copy database field, you should enter a name for the new duplicate database.
Please select the following options:
'Structure and Data'
'CREATE DATABASE before copying'
'Add AUTO_INCREMENT value'
and then click the Go button:
Useful Links