Is there any way to clone a mysql database in linux/windows server without taking dump and import it again to another db.
If there is a solution please give me the answer.
This worked perfectly for my requirement
mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2