mysql_backup.sh

#!/bin/bash

BACKUP_DIR="/var/lib/mysql/backup"

if [ -n "`pidof mysqld`" ] && [ -f "/var/lib/mysql/.my.cnf" ]; then
    mkdir -p $BACKUP_DIR
    chown mysql $BACKUP_DIR

    # backup datqabases
    # please create /var/lib/mysql/.my.cnf
    # [mysqldump] [mysql]
    # user=mysql
    # password=secret
    runuser -c 'mysql -Bse "SHOW DATABASES"|xargs -i sh -c "mysqldump --opt {} > /backup/data/mysql/{}.mysql"' mysql

fi