Backup script for MariaDB (or MySQL). Placed in /etc/cron.hourly/. Creates a backup of all databases every hour and keeps the current plus nine previous versions.

backup-mysql-db

#!/bin/bash

BASENAME="/var/backups/MySQL-Backup.gz"
x=9

rm "$BASENAME.$x"

while [ $x -gt 1 ]
do
    y=$(( $x - 1 ))
    mv "$BASENAME.$y" "$BASENAME.$x"
    x=$(( $x - 1 ))
done

mv "$BASENAME" "$BASENAME.1"

umask 0027

# Seit 26.04.2013 kommt ohne "--events" die Meldung:
# Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
/usr/bin/mysqldump --all-databases --events --password=PASSWORD --user=root --host=localhost \
    | gzip --stdout \
    > "$BASENAME"