#!/bin/sh

############################
#
# back_daily.ftp - Shell script to perform daily backups
# by Marcos Labad <marcos@acilia.es>
#
#############################


echo "OK, starting now..."
DAY=`date +%d`
echo Backup for Day: $DAY

#######################
# MySQL Operations
#######################

echo Starting Mysql

mysqldump -uUSERNAME -pPASSWORD --all-databases > mysql_backups/mysql-latest.sql

echo Mysql is finished 

#######################
# File Operations
#######################

echo Starting File ZIP generation

zip -r file_backups/files_back_$DAY.zip public_html/* 
zip -r file_backups/files_back_$DAY.zip hostx/* 
zip -r file_backups/files_back_$DAY.zip hosty/* 
zip -r file_backups/files_back_$DAY.zip hostz/* 
zip -r file_backups/mysql_back_$DAY.zip mysql_backups/mysql-latest.sql

echo Files process is finished

######################
# FTP Operations
######################

echo Starting FTP Transfer

ftp -n FTP-HOST-NAME.com <<EOF
user USERNAME PASSWORD 
binary
cd acilia 
lcd file_backups
put files_back_$DAY.zip 
put mysql_back_$DAY.zip 
quit
EOF

echo FTP Transfer finished