#!/bin/sh

db_user='admin'
db_pass='admin'
dir=/str1/backups/mysqlbackup
date=`date "+%Y%m%d"`
dbs=`echo 'show databases;' | /usr/bin/mysql -u $db_user --password=$db_pass  | grep -v information_schema | grep -v Database`

for loop in $dbs
do
  /usr/bin/mysqldump  --add-drop-table -u $db_user --password=$db_pass $loop > $dir/$loop.sql
  gzip -f7 /str1/backups/mysqlbackup/$loop.sql
done

/usr/bin/mysqldump -u $db_user --password=$db_pass --all-databases > $dir/full_mysql_backup.sql
gzip -f7 /str1/backups/mysqlbackup/full_mysql_backup.sql