#!/bin/bash

DIR=/home/www/backup

HOSTNAME=localhost
DBNAME=db_name
DBPASS=pass
DBUSER=user

DATE=`date +%Y%m%d-%H%M%S`

# 1. BACKUP PROCEDURE FOR FILES

tar cz -C /home/www/site1/public -f $DIR/site/public-$DATE.tar.gz system

# 2. BACKUP PRODECURE FOR MYSQL DATABASE

mysqldump --opt -h $HOSTNAME -u$DBUSER -p$DBPASS $DBNAME | gzip -9 > $DIR/mysql/site1-$DATE.gz

find $DIR/mysql/* -mtime +7 -exec rm {} \;
find $DIR/site/* -mtime +2 -exec rm {} \;

rsync -zthr --compress-level=9 $DIR/ rsync://server.ru/with_rsync