#!/bin/bash

echo "Programma di backup dei database."

cd "/var/www/vhosts/fotocontest.it/mysqldump"

function backup {

    echo -n "  - Backup di $1... "
    filename="$1@`date +%F-%H-%M-%S`.sql"
    mysqldump --user=$2 --password=$3 --databases $1 > "$filename" 2> /dev/null

    if test $? = 0; then

    echo -n "Completato. "
    echo -n "Compressione... "
    compressed="$filename.tar.gz"
    tar czfv "$compressed" "$filename" > /dev/null
    osize=`hsize $filename`
    rm "$filename"
    size=`hsize "$compressed"`
    echo "Fatto ($osize > $size)."

    else

    echo "Errore."

    fi

}

function hsize {
    size=`du -h "$1"`
    size=`echo $size | sed -e 's/[ \t]/-/'`
    size="${size%%-*}"
    echo -n "$size"
}

password="14-12a3zyt8"

backup Sql111310_1 Sql111310_1 $password
backup Sql111310_2 sql111310_1 $password
backup Sql111310_3 Sql111310_3 $password
backup Sql111310_5 sql111310_5 $password