[root@kino cron.daily]# cat mysqlBackup
#!/bin/bash

backup_dir=/storage/.hbackup/mysql/$(date +'%Y')/$(date +'%m')/$(date +'%d')/$(date +'%T')

DATABASES=(mysql forum up wikidb)
USER="root"
PASSWORD="not_realy_password"
RIGHTS="0400"
OWNER="root.root"

# =================
echo "Optimizing all DB"
mysqlcheck --user=$USER --password=$PASSWORD --all-databases --analyze --auto-repair --optimize

echo "Creating dir: $backup_dir"
mkdir -v -p $backup_dir
echo "Go to dir: $backup_dir"
cd $backup_dir

if [ "${DATABASES[*]}" ]; then
    for database in ${DATABASES[@]}; do
        echo "dumping: $database "
        /usr/bin/mysqldump --user=$USER --password=$PASSWORD $database > $backup_dir/${database}.sql

        chmod $RIGHTS $backup_dir/${database}.sql
        chown $OWNER $backup_dir/${database}.sql

        echo " zipping file"
        pbzip2 -l $backup_dir/${database}.sql
        gpg --homedir='/root/.gnupg' -e -r dimkalinux@gmail.com $backup_dir/${database}.sql.bz2
        rm -f  $backup_dir/${database}.sql.bz2
    done
fi