Normally we have to copy one database to another on the same server we download the SQL file of one DB and import it into another. Read full article here: https://codedrill.in/mysql-cloning-a-mysql-database-on-the-same-mysql-instance/