#!/bin/sh

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


echo "OK, starting now..."
MONTH=`date +%m`
echo Backup for Month: $MONTH

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

echo Starting Mysql

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

echo Mysql is finished 

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

echo Starting File ZIP generation

zip -r file_backups/files_back_month_$MONTH.zip public_html/* 
zip -r file_backups/files_back_month_$MONTH.zip hostx/* 
zip -r file_backups/files_back_month_$MONTH.zip hosty/* 
zip -r file_backups/files_back_month_$MONTH.zip hostz/* 
zip -r file_backups/mysql_back_month_$MONTH.zip mysql_backups/mysql-month-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_month_$MONTH.zip 
put mysql_back_month_$MONTH.zip 
quit
EOF

echo FTP Transfer finished