#!/bin/bash
echo "Backup databases by Nikow."
#Pobranie danych inicjujacych.
BACKUPSDIR=$1
USER=$2
PASS=$3
DATA=`date +"%Y-%m-%d"`

#Katalogi
if [ ! -d &BACKUPSDIR ]
    echo "Katalog ${BACKUPSDIR} istnieje."
    mkdir -v $BACKUPSDIR
    if [ "$?" != "0" ]
        echo "ERROR!"
        exit 1

mkdir ${BACKUPSDIR}/${DATA} >& /dev/null
cd ${BACKUPSDIR}/${DATA}

#Wyciaganie baz.
BAZY=`echo "show databases;" | /usr/bin/mysql --silent -u${USER} -p${PASSWORD}

#Dump
for BAZA in $BAZY; do
    echo "Zrzucanie bazy ${BAZA}..."
    /usr/bin/mysqldump --add-drop-database --add-drop-table --complete-insert \
        --create-options --single-transaction -u${USER} -p${PASSWORD} \
        ${BAZA}.sql
done;

#Kompresja
echo "Kompresja baz..."
nice -15 gzip -9vl *
echo "KONIEC!"