====== MySQL backup script ======

Simple script to backup all MySQL databases to specific folder:

<code bash>
#!/bin/bash

# === SETTINGS ===
DEFAULTEXTRA="/usr/local/directadmin/conf/my.cnf"
DUMPDIR="/home/sqldumps"
# ================

# Create backup dir
/bin/mkdir -p ${DUMPDIR}

# Backup job
while read DB
	do
		/usr/bin/mysqldump --defaults-extra-file=${DEFAULTEXTRA} ${DB} | /usr/bin/gzip > "${DUMPDIR}/${DB}-$(date +%Y-%m-%d_%H%M).sql.gz";
	done < <(/usr/bin/mysql --defaults-extra-file=${DEFAULTEXTRA} -NBe 'show databases;' | egrep -v 'information_schema|performance_schema')

# Clean old backups:
/usr/bin/find ${DUMPDIR} -type f -mtime +7 -name "*.sql.gz" -exec /bin/rm -rf {} \;
</code>