Simple script to backup all mysql databases & store them on remote server (in silent mode)

backup.sh

#!/bin/sh

HOST="localhost"
USER="root"
PASSWORD="root"
DB="--all-databases"
DATE=`date +%Y-%m-%d.%H.%M.%S`
NAME="mysql.backup.${DB}.${DATE}.sql.gz"
COMMAND="mysqldump -h ${HOST} -u ${USER} -p$PASSWORD ${DB} | gzip -c > ${NAME}"
SCP_COMMAND="scp ${NAME} user@backup-server:/path/to/backup/folder/"
eval $COMMAND
if [ -e "$NAME" ]; then
  # copy gzipped backup to remote server.
  eval $SCP_COMMAND
  # delete after copied to target server. 
  rm -rf $NAME
fi