How to restore mysqldump of one database in different databaseName with content of data in the same host machine
How to restore mysqldump of one database in different databaseName with content of data in the same host machine


I would like to say that as I am able to restore the backup of DB1 in DB2 with the same host. When I took the mysqldump backup of DB1 from the SQLyog ultimate tool. During the mysqldump backup window just exclude these statements. Which is as follows:


Exclude USE database statement
Exclude CREATE database statement


After excluding these statements in dump file , I am able to restore the dump backup file at DB2 (Different database name with mysqldump database name) in same host name.

Hope it will helpful to other person.