Create a new database that is an exact copy of the source database. You can also copy a database content to a database that already exists (destination). In such a case, the tables from the source database will be added to those in the destination database. If a table name is the same in the source and destination databases, then the table from the source will replace the one in the destination.
1) Login to Plesk control panel.

2) Click on Websites & Domains > Click Databases.

3) Select the corresponding Database Name from the list. > Click Copy.

4) Follow the steps as marked in RED.

5) Then Make a Database user from User Tab > as deails showing in RED.

6) Click Ok.
