mysqldump script using pt-show-grants

mysqldump.sh

#!/usr/bin/env bash

#  wget percona.com/get/percona-toolkit.deb

declare -r \
_BACKUP_DIR="/root/backup/" \
_OCCURRENCES=24

# Get the real number of backup occurrences and delete the old ones
function delete () {
	if [ -z "${1}" ] ; then
		return 1
	fi

	local _name="${1}"
	local _real_occurrences="$(ls "${_BACKUP_DIR}" | grep -c "${_name}")"

	if [ "${_real_occurrences}" -ge "${_OCCURRENCES}" ] ; then
                ls -tl "${_BACKUP_DIR}"* | grep "${_name}" | awk '{ print $NF }' | tail -$((_real_occurrences - _OCCURRENCES)) | xargs rm
        fi
	return 0
}

mysql -N -e 'show databases;' | grep -v 'performance_schema' | while read _db;
do
	mysqldump --events --single-transaction "${_db}" | gzip -9 -c > "${_BACKUP_DIR}${_db}_$(date +'%F_%T').sql.gz"
	delete "${_db}"
done

# Export grants with percona toolkit
pt-show-grants | gzip -9 -c >"${_BACKUP_DIR}grants_$(date +'%F_%T').sql.gz"
delete "grants"

exit 0