backup-mysql.sh

#!/bin/bash

TARGET="/backup/mysql"

egrep -v "^(#|\\s*$)" /etc/duply/default/enabledDBs | while read DATABASE ; do
        # this works securly for all tables in this database. It locks all tables (no read or write) and dumps them.
        # Inculding creat db-statment. The quick options dumps to ram, and flushes then. This leads to less locktime.
        mysqldump --lock-tables --quick --databases ${DATABASE} | gzip > ${TARGET}/${DATABASE}.mysql.gz
done