Copy A MySQL Db Using SSH

 

 

Using SSH the best way to copy a MySQL db from another server is:


mysqldump -h OLD_SERVER -u USER -pPASS DBNAME | mysql -u NEWUSER -pNEWPASS NEWDB


 

Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 9571

Need more information or have a question ?