Backup the database from bash, zip it and delete any older then X days. Good to use with Cron when hosting websites.

backupdb.sh

#!/bin/bash
# replace what is in [[ ]] with necessary variables

# Database credentials
 user="[[username]]"
 password="[[password]]"
 host="[[host]]"
 db_name="[[database_name]]"
# Other options
 backup_path="[[path_to_backup_folder]]"
 date=$(date +"%d-%b-%Y")
# Set default file permissions
 umask 177
# Dump database into SQL file
 mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql
 zip -9 $backup_path/$db_name-$date.sql.zip $backup_path/$db_name-$date.sql
 rm $backup_path/$db_name-$date.sql
# Delete files older than X days
 find $backup_path/* -mtime +[[X]] -exec rm {} \;