MySQL database backup script

#!/bin/bash

export PATH=/bin:/usr/bin:/usr/local/bin
TODAY=`date +"%m-%d-%y-%H%M"`

DB_BACKUP_PATH='/home/solodbadm/backup'
MYSQL_HOST='localhost'
MYSQL_PORT='3306'
MYSQL_USER='solodb_admin'
MYSQL_PASSWORD='password'
DATABASE_NAME='solodb_production'
BACKUP_RETAIN_DAYS=5   ## Number of days to keep local backup copy

#################################################################

#Remove older backups
find ${DB_BACKUP_PATH} -mtime +${BACKUP_RETAIN_DAYS} -type f -delete

echo "Backup started for database - ${DATABASE_NAME}"

mysqldump \
   --single-transaction \
   -h ${MYSQL_HOST} \
   -P ${MYSQL_PORT} \
   -u ${MYSQL_USER} \
   -p${MYSQL_PASSWORD} \
   ${DATABASE_NAME} | gzip > ${DB_BACKUP_PATH}/${DATABASE_NAME}-${TODAY}.sql.gz

rsync -avP -e 'ssh -p 1222' ${DB_BACKUP_PATH}/* jield@your-server-hostname:/volume1/jield-backup

if [ $? -eq 0 ]; then
  echo "Database backup successfully completed"
else
  echo "Error found during backup"
fi