It is easy to create a copy file of database used by your account. In order to proceed you need to use phpMyAdmin in your cPanel.
1] Login to cPanel account >> Select phpMyAdmin >>
phpMyadmin will be loaded shortly.
2] Select database that you would like to backup. At left side of the page you’ll see the database list.
3] Click on the Export tab once web page screening the selected database.
4] Click on the saves as file option, which will save the file on your PC >> You can select database format either CSV, CSV for Excel or in .sql format.
5] If the table already exists in the database backup and you want to add table functionality you should select ADD DROP TABLE option.
6] To import .sql file >> Click on the Import option (right side on the export tab).
7] Click on the Browse button to select .sql file from your local PC.
8] You can choose the character set of the file from the drop down menu just below the upload file box. If you are not sure about the character set of your database leave it as default.
9] In order to proceed click on the Go button (bottom of the right).
