Some SSH functions for backing up a MYSQL DB, zipping it and shipping it off to a remote server.

SSH MYSQL commands

// Obviously {this} means replace with your version of this

// Dump DB
mysqldump -p -u {username} {dbname} > {dbname.sql}

// Tar DB
tar -cvf {dbname.tar} {dbname.sql}

// Move DB
curl -T {dbname.tar} ftp://{remote path}/{dbname.sql} --user {username}:{password} -v

// Remove leftovers
rm {dbname.sql}
rm {dbname.tar}

// If you want to install on the remote server
tar -xvf {dbname.tar}
mysql -u {username} -p {dbname} < {dbname.sql}