#!/bin/sh
FIND=/usr/bin/find
GZIP=/bin/gzip
MYDUMP=/usr/bin/mysqldump
# find all databases and export them
for i in `(cd /var/lib/mysql/; ${FIND} * -type d -user mysql) 2>/dev/null`; do

	# if old file exists, delete it
	if [ -f /backup/mysqlbackup/$i.sql.gz.2 ]; then
		mv /backup/mysqlbackup/$i.sql.gz.2 /backup/mysqlbackup/$i.sql.gz.3
	fi
	if [ -f /backup/mysqlbackup/$i.sql.gz.1 ]; then
                mv /backup/mysqlbackup/$i.sql.gz.1 /backup/mysqlbackup/$i.sql.gz.2
        fi
	if [ -f /backup/mysqlbackup/$i.sql.gz ]; then
                mv /backup/mysqlbackup/$i.sql.gz /backup/mysqlbackup/$i.sql.gz.1
        fi

	# dump current database
        ${MYDUMP} --lock-tables --user=root --password=****** --databases $i | $GZIP > /backup/mysqlbackup/$i.sql.gz

done