#!/bin/sh
#change directory to your backup directory
cd /home/xxx/backup_dbs/;
#get backup of database of applications
mysqldump --user='myuser' --password='mypw' mydb >tmp_db.sql;
#compress it in zip file
zip app_database-$(date +%Y-%m-%d-%H:%M).sql.zip tmp_db.sql;
#remove  sql file
rm -rf tmp_db.sql;
#delete backups older than 20 days
find /home/xxx/backup_dbs/app* -mtime +20 -type f -delete;

/home/xxx/backup_dbs/backup.sh