Here is a little bash script I wrote to do a daily backup of my databases.
This script will work unattended if you have ssh keys set up already so you won't be asked for credentials.

dbBackup.sh