Creacte Mysql Database copy
You can do it in two ways :

1 Backup &amp; Restore :

Take backup using mysqldump &amp; restore backup with new name.

2 Manual Create Table in New Database :

create schema new_schema;

select concat(&quot;create table new_schema.`&quot;,table_name,&quot;` as select * from `&quot;,table_schema,&quot;`.`&quot;,table_name,&quot;`;&quot;)
from
information_schema.tables 
where table_schema='old_schema'; 

/* Execute the above statement output simultaneously*/

-- i.e
create table new_schema.`XXX` as select * from `njindiainvest`.`XXX`;
create table new_schema.`YYY` as select * from `njindiainvest`.`YYY`;
create table new_schema.`ZZZ` as select * from `njindiainvest`.`ZZZ`;