[(11:41):artem@28321-1:~ ] cat mysql-backup.sh
#!/bin/sh
USERNAME="root"
PASSWORD="[skip]"
WDIR="/home/artem/backup/mysql"
for base in ejabberd pyicqt postfix
do
          `/bin/mkdir -p $WDIR/$base`
          `/bin/chmod 700 $WDIR/$base/`
          `/usr/bin/mysqldump -u $USERNAME -p$PASSWORD -B $base > $WDIR/$base/backup_$base.sql`
          `/bin/gzip -cf9 $WDIR/$base/backup_$base.sql > $WDIR/$base/$base'_'$(date +%Y-%m-%d).gz`
          `/bin/rm $WDIR/$base/*.sql`
          `/bin/chmod -R o-rwx $WDIR`
done