Export a mysql database and move the dump to another server via sftp

mysql_sftp_backup_script.sh

#!/bin/bash

DBNAME="dbname"
DBHOST="localhost"
DBUSER="root"
DBPASS="12345"

SFTPUSER="username"
SFTPHOST="host"
SFTPPATH="/path/to/backup/directory"




# Oh Oh Oh Oh, cant't touch this

# Generate output file name
FILENAME=db_backup_$(date +"%Y_%m_%d_%H_%M_%S").sql
OUTPUTFILE=~/.tmp/db_backup_script/$FILENAME
ZIPPEDOUTPUTFILE=${OUTPUTFILE}.tar.gz

# Create temp dir
mkdir -p ~/.tmp/db_backup_script

# Export database to file
mysqldump -h $DBHOST -u $DBUSER -p$DBPASS $DBNAME > $OUTPUTFILE

# Zip the file
tar cfz $ZIPPEDOUTPUTFILE $OUTPUTFILE

# Upload file
scp $ZIPPEDOUTPUTFILE ${SFTPUSER}@${SFTPHOST}:${SFTPPATH}/${FILENAME}.tar.gz

# Clean up
rm -rf ~/.tmp/db_backup_script