mysql backup cron job

mysql_backup.sh

#!/usr/bin/env bash
#
# Schedule in cron as local time 11:00PM local time (e.g. PST '00 07 * * * bash /home/antarctica/backup_cloudera_db.sh)

user=root
password=root_password
database=scm
archive_days=7

# Backing Up MySQL Databases
sudo bash -c 'mysqldump -hlocalhost -u$user -p$password $database | gzip -9  > /data01/backup/cm_scm_db.$(date +%Y%m%d).sql.gz'

# Backing Up PostgreSQL Databases
#PGPASSWORD=$password pg_dump -h localhost -p 7432 -U $database | gzip -9 > /data01/backup/pgsql_scm_server_db_backup.$(date +%Y%m%d).sql.gz

sudo find -name *.gz -type f -mtime +$archive_days -exec rm -f {} \;