You can use Phpmyadmin in cpanel to copy a database easily.
1
Login to your hosting control panel (cPanel) and click PhpMyadmin in the databases section.
2
Select the database that you wish to copy from the main menu.I have selected example_testing database from the main menu.
3
After selecting the desired database click on the operations tab from the next page .
4
Provide the name of the new database in the “copy database to” tab.
5
While choosing the database name ensure that the following options are checked.
- Structure and data
- CREATE DATABASE before copying
- Add AUTO_INCREMENT value
6
Click “Go” after providing the database name . Your database will be copied to the new database name.
