Running mysqldump via ssh (direct host to host copy)

In order to run a mysqldump from one host to another over SSH you can run: mysqldump dbname | ssh [email protected] "mysql -D dbname" This will pipe the output of mysqldump directly to the ssh connection which is running MySQL at the other end and receiving the mysqldump from standard input.

← Back to Blog