dbdump.sh

#! /bin/bash
TIMESTAMP=$(date +"%d-%m-%Y_%H%M")
BACKUP_DIR="/home/darek/backup/mysql"
CURRENT_BACKUP_DIR="$BACKUP_DIR/$TIMESTAMP"
MYSQL_USER="root"

mkdir -p $CURRENT_BACKUP_DIR

find $BACKUP_DIR -mindepth 1 -maxdepth 1 -type d -mtime +7 -exec rm -rf '{}' +;
 
databases=`mysql -u$MYSQL_USER -e "SHOW DATABASES;" | grep -Ev "(Database|mysql|information_schema|performance_schema)"`
 
for db in $databases; do
  mysqldump --force --opt -u$MYSQL_USER --databases $db | gzip > "$CURRENT_BACKUP_DIR/$db.sql.gz"
done

gistfile1.txt

0 10,12,14,16 * * * /usr/bin/dbdump >/dev/null 2>&1