#!/bin/sh
#This variable grabs the date. This is can be appended to your backup file name so you can keep archives of your data.
 
BACKUPDATE=`date +%Y-%m-%d`
 
#These are variables which you set depending on your system.
#The path to where you will create the tar backup on the remote server
BACKUPDIR=/home/dave
 
#The name of the database you wish to backup
DBNAME=myimportantdatabase
 
#This is the name database which has backup rights to the remote database. Hopefully you aren't using root!
DBUSER=myimportantdatabaseuser
 
#This is the password of the database user. 
DBPASSWORD='Passw0rd'
 
#This is the path of the database backup. The database dump.
 
MySQLFILE=$BACKUPDIR/$BACKUPDATE.$DBNAME.sql.gz
 
#Run Backup Commands
 
#Run a secure remote command for mysqldump
ssh dave@www.myserver.co.uk "mysqldump  -u$DBUSER -p$DBPASSWORD $DBNAME | gzip > $MySQLFILE"
 
#Copy the database dump backup to the qnaps local files system
scp dave@www.myserver.co.uk:$MySQLFILE /share/HDA_DATA/dave/backups/db/
 
#Delete the backup file from the remote server - you don't need it anymore now you have copied it to your QNAP.
 
ssh dave@www.myserver.co.uk "rm -r -f $MySQLFILE"