$ cp mysqlhourlybackup.sh /usr/local/bin && chmod +x /usr/local/bin/mysqlhourlybackup.sh
Edit the variables
nano /usr/local/bin/mysqlhourlybackup.sh
- set MYSQL_USER
- set MYSQL_PASSWORD
- set MYSQL_HOST
- set ENCRYPTPASSWORD
crontab -e
00 * * * * /usr/local/bin/mysqlhourlybackup.sh >/dev/null 2>&1
openssl enc -aes-256-cbc -d -in *dbname.enc* -out database.gz -pass pass:*encryptionpassword* && gunzip -c database.gz > *dbname.sql*