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.
Asked
Active
Viewed 135 times
0
-
maybe import the physical data from server a to server b -> http://dev.mysql.com/doc/refman/5.0/en/copying-databases.html – Marco Mura Dec 23 '14 at 09:21
-
I dont understand can you please brief more. – Hoja Dec 23 '14 at 09:23
-
added in my comment before the link to mysql documentation – Marco Mura Dec 23 '14 at 09:24
-
1[link for your solution][1] [1]: http://stackoverflow.com/questions/25794/mysql-copy-duplicate-database hope will help – magic-sudo Dec 23 '14 at 09:24
1 Answers
0
This worked perfectly for my requirement
mysqldump -h [server] -u [user] -p[password] db1 | mysql -h [server] -u [user] -p[password] db2
Hoja
- 1,057
- 1
- 12
- 32