mysql_backup.sh

password="#{database_password}"
database_name="#{database_name}"
 
file_name=Dump_${database_name}_$(date +%d%m%Y_%H%M)
mkdir -p ~/backups && cd ~/backups
 
mysqldump -u root -p$password $database_name > $file_name.sql
tar czfv $file_name.tar.gz $file_name.sql
rm $file_name.sql
 
# Remove backups older than 15 days
find ~/backups -type f -mtime +15 -exec rm -f {} \;