#!/bin/tcsh

(ssh marvin mysqldump --opt --single-transaction smf )|gzip -9 > ~/backups/output/forums_db/`date +%F_%H-%M-%S`_mydb.sql.gz

# Note:  We are now storing the password in marvin:~/.my.cnf
# Marvin has a new version of mysql and it was complaining that putting the password on the command line is bad.  It was sending us emails every night complaining.  :(
# For instrunctions on using ~/.my.cnf see
# https://stackoverflow.com/questions/16299603/mysql-utilities-my-cnf-option-file