如何使用shell和终端克隆mysql数据库而不进行mysql转储和上传

Question

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.

Answer 1

This worked perfectly for my requirement

mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2