#!/bin/bash

cd /path

echo -n "Backup started:" > backup.log
/bin/date >> backup.log

DBUSER="--user=user"
DBPASS="--password=pass"
DBOPTIONS="--opt --hex-blob --force"
DBLOGIN="$DBUSER $DBPASS"

dblist=`echo show databases\; | mysql $DBLOGIN | grep -v Database`

for dbname in $dblist
do (
  echo -n "`date '+%c'` Backing up $dbname: " >> backup.log
  echo -n "Dump cycle" >> backup.log
  /usr/bin/mysqldump $DBOPTIONS $DBLOGIN $dbname > ${dbname} 2>> backup.log
  echo -n "Compression Cycle" >> backup.log
  /usr/bin/p7zip ${dbname} >> backup.log
  echo "" >> backup.log
)
done

echo -n "Moving compressed files" >> backup.log
mkdir `date +%Y%m%d`
mv *7z `date +%Y%m%d`

echo -n "Backup ended: >> backup.log
/bin/date >> backup.log
mv backup.log `date +%Y%m%d`