Re: transfer mysqldump backup via SSH

[Benny Pei]

Machine_A: mysql_box
Machine_B: local_box where you want to keep the mysqldump files

you need to do one thing. Setup a one way ssh passphrase-less connection from mysql@Machine_A -> root@Machine_B (ie when mysql user from Machine A connect to Machine B as a root user, the ssh session is trusted) How to set this up? Talk to your sysadmin. But I think having a passphraseless to a root user is probably not a good idea. Anyway, if that is what you want, be aware of the security risk.

Once the passphrase less connection is set, test it
login to Machine_A as mysql
ssh to Machine_B as root

e.g.
mysql% ssh root@Machine_B
root%

This should connect to Machine_B and you are root once you are logged in.

So test is good. If that fails, go back and check your ssh passphrase between Machine_A and Machine_B

So all of this is set,

save mysqldump command into a shell script

In the shell script, after the mysqldump is done
add `scp file.sql root@Machine_B:/localdir/file.sql`

that is it.