1. Copy One database to another database on same host
mysqldump -uroot -p | mysql -uroot 2. Copy database to another database on remote host
mysqldump -uroot -p | ssh host2 "mysql -uroot "
Copy database to another database through command
1. Copy One database to another database on same host
mysqldump -uroot -p | mysql -uroot 2. Copy database to another database on remote host
mysqldump -uroot -p | ssh host2 "mysql -uroot "
Sandip is a ruby on rails developer based in pune and also a blogger at funonrails. Opensource contributor and working with Josh software Private Limited. for more info read Follow Sandip on Twitter for updates.
