#!/bin/bash
# Ustawienia
backup_path="/var/www/vhosts/folder/KOPIA"
date=$(date +"%d-%m-%Y")
# FTP
HOST=domena.pl
USER=test
PASS=test
# MYSQL
LOGIN=test
PASSWORD=test
# TWORZYMY FOLDER Z DATA
mkdir $backup_path/$date
umask 177
# Dump baz danych
mysqldump -u$LOGIN -p$PASSWORD --databases baza1 > $backup_path/$date/SQL-baza1-$date.sql
mysqldump -u$LOGIN -p$PASSWORD --databases baza2 > $backup_path/$date/SQL-baza2-$date.sql

cd $backup_path/$date;
zip -r $backup_path/SQL-$date.zip *
rm -fr $backup_path/$date

# USUWAMY STARSZE NIZ 3 DNI
find $backup_path/*.zip -mtime +3 -exec rm {} \;
# LACZYMY SIE Z FTP HOME
ftp -inv $HOST << EOF
user $USER $PASS
# WGRYWAMY PLIK
put $backup_path/SQL-$date.zip /KOPIA/SQL-$date.zip
# USUWAMY Z HOME STARSZE NIZ 3 DNI
bye