#!/bin/sh  
# Exit the script if an error happens
set -e 

if [ -f ~/.bash_profile ];
then
  . ~/.bash_profile
fi 

#01 23 * * * /home/dbbackup/auto_backup_crmdb.sh

backup_path="/home/dbbackup/"
add_file="`date '+%Y%m%d'`"
del_file="`date -d \"-30 day\" \"+%Y%m%d\"`"

#echo $add_file
#echo $del_file

#/usr/local/mysql/bin/mysqldump --login-path=crmbackup --set-gtid-purged=off --opt -R -E ldcrm | gzip>$backup_path/$add_file.sql
/usr/local/mysql/bin/mysqldump --user=root --host=127.0.0.1 --password=lingdang## --set-gtid-purged=off --opt -R -E ldcrm>$backup_path/$add_file.sql


if [  -f "$backup_path/$add_file.sql" ]; then
	cd $backup_path
	zip -r $add_file.zip $add_file.sql
	rm -rf "$backup_path/$add_file.sql"
fi

if [  -f "$backup_path/$del_file.zip" ]; then
	rm -rf "$backup_path/$del_file.zip"
fi