Posts and pages
For example, if you have database called db_name that you want to copy to new_db_name, you would first create a “database dump” file using:

mysqldump -u db_name -p db_name > a.dump

It will prompt for db password enter it here.

Then create the new database via web hosting control panel

mysql -u new_db_name -p new_db_name < a.dump

It will prompt for db password enter it here