mysql auto backup script.sh

#!/bin/bash

# Database credentials
user="xxx"
password="xxx"
host="xxx"
db_name="xxxx"

# Other options
backup_path="/data/backup/mysql"
d=$(date +"%F-%T")

# Set default file permissions
umask 177

# Dump database into SQL file
mysqldump --user=$user --password=$password $db_name > $backup_path/$db_name-$d.sql

# Delete files older than 30 days
find $backup_path/* -mtime +30 -exec rm {} \;

#scp to remote server
sshpass -p "xxxx" scp $backup_path/$db_name-$d.sql xxx@domain.com:/path/backup/