#!/bin/sh

#PARAMETERS
FTP_HOSTNAME='ftpback-rbx4-68.ovh.net'
FTP_USERNAME='ns388294.ovh.net'
FTP_PASSWORD='RPTwAP7brGz'
DB_USERNAME='root'
DB_PASSWORD='B@k2'
DATE_DAY=`date +%Y%m%d`
DATE_DELETE=`date +%Y%m%d --date '20 days ago'`

#ROUTINE STARTED
echo "Backup routine started"

#Go to routine backup folder
cd /home/share/routine/backup
echo "Current location: ${pwd}" `pwd`


#Database backup
db_dump_name=aurora_$DATE_DAY.sql;
mysqldump -u $DB_USERNAME -p$DB_PASSWORD aurora > $db_dump_name

#Delete database backup -20jours
db_dump_name_delete=aurora_$DATE_DELETE.sql;

#Application sources backup
#sources_dump_name=sources_$DATE_DAY.tar.gz
#tar cfvz $sources_dump_name /home/backoffice/www/ /home/pos/www/v3-advanced/ /home/testunit/www/ /home/share/


#FTP connection
ftp -n $FTP_HOSTNAME <<END_SCRIPT
quote USER $FTP_USERNAME
quote PASS $FTP_PASSWORD
cd /backup/database
put $db_dump_name
ls
delete $db_dump_name_delete
quit
END_SCRIPT

#cd /backup/application
#put $sources_dump_name
#ls

#rm $sources_dump_name
cp $db_dump_name /home/backup/database_dump.sql
rm $db_dump_name

#ROUTINE FINISHED
echo "Backup routine finished"