#!/bin/bash

DATABASES=(
"datenbank_name"
"zweiter_datenbank_name"
)
PATHS=(
"/dein/pfad/zum/backup/"
"/dein/pfad/zum/zweiten/backup/"
)
USERNAME="username"
MAX_COUNT=3
PASSWORD="password"
timestamp="$(date +"%Y_%m_%d_%H_%M")"

for (( i = 0; i < ${#DATABASES[@]}; ++ i )); do
	DATABASE="${DATABASES[i]}"
	FILES=( $(/bin/ls "${PATHS[i]}${DATABASE}"_* | /usr/bin/sort -n -t _ -k 2) )
	if [ ! -d "${PATHS[i]}" ]; then
		/bin/mkdir -p "${PATHS[i]}"
	fi
	if [ "${#FILES[@]}" -gt "${MAX_COUNT}" ]; then
		END=$((${#FILES[@]} - ${MAX_COUNT}))
		for x in $(eval echo {0..$END}); do
			FILE="${FILES[x]}"
			if [ -f "$FILE" ]; then
				/bin/rm "$FILE"
			fi
		done
	fi
	PATH="${PATHS[i]}${DATABASE}_${timestamp}.sql.gz"
	/usr/bin/mysqldump --user="$USERNAME" --lock-tables=FALSE --password="$PASSWORD" "$DATABASE" | /bin/gzip -9 -f >"$PATH"
	/bin/chmod 0777 "$PATH"
done