#!/bin/bash
#
##############################
#bak mysql  ldap
#############################
# Freid
# dongfei_19@163.com


BkDf=1
RNum=$(($RANDOM%30+26))
BkN=$(grep $(hostname) /etc/hosts /home/common/etc/hosts.conf |grep -oE "[0-9][0-9]*\.[0-9][0-9]*\.[0-9][0-9]*\.[0-9][0-9]*"|xargs |sed 's# #-#g')
BkIp=192.168.66.201
BkNa=zwbk
BkPa=qwe@123
FtpD=data
MysqlPath="/opt/databk/date/"
LdapPath="/opt/databk/date/"
Path="/opt/databk/date"
File_Date=7
Date=`date +"%Y%m%d%H%M%S"`

BakUp() {
sleep ${RNum}
ftp -i -v -n ${BkIp}  << END
user ${BkNa} ${BkPa}
cd ${FtpD}
lcd ${Path}
put ${BkN}.tar.gz
!\rm -f ${BkN}.tar.gz
bye
END
}

cd ${Path}

#备份mysql
/usr/bin/mysqldump -u root -pZwkj@123Mysql  --add-drop-database  --add-drop-table --databases  clbs > ${MysqlPath}clbs_date_${Date}.sql
#/usr/bin/mysqldump -u root -pZwkj@123Mysql clbs --databases --ignore-table=clbs.zw_m_media --ignore-table=clbs.zw_c_log > ${MysqlPath}clbs_date_${Date}.sql
#/usr/bin/mysqldump -u root -pZwkj@123Mysql  --add-drop-database  --add-drop-table --databases  clbs  \
#  --ignore-table=clbs.zw_m_media  \
#  --ignore-table=clbs.zw_m_vehicle_spot_check  \
#  --ignore-table=clbs.zw_m_vehicle_adas_online_time \
#  --ignore-table=clbs.zw_s_orgnization_alarms  \
#  --ignore-table=clbs.zw_m_video_flow \
#  --ignore-table=clbs.zw_m_monitor_score_month_report \
#  --ignore-table=clbs.zw_s_orgnization_alarms \
#  --ignore-table=clbs.zw_m_assignment_user_old  \
# $(mysql -uroot -pZwkj@123Mysql -e 'show tables from clbs;' | awk -F \| '{print $1}' |grep -v Tables | grep -oE "^[A-Z].*|zw_log_.*" | sed "s#.*#--ignore-table=clbs\.&#g"|xargs)  > ${MysqlPath}clbs_date_${Date}.sql
cd ${MysqlPath} &&  tar -czf clbs_date_${Date}.sql.tar.gz clbs_date_${Date}.sql --remove-files

#备份ldap
cd ${LdapPath} && tar -czf ldap_date_${Date}.tar.gz /var/lib/ldap/

[[ "$BkDf" == "0" ]] && cd ${Path} && tar -zcf ${BkN}.tar.gz clbs_date_${Date}.sql.tar.gz ldap_date_${Date}.tar.gz && sleep 3 && BakUp

#删除陈旧备份
find $MysqlPath -type f -mtime +$File_Date | xargs rm -f 
find $LdapPath -type f -mtime +$File_Date | xargs rm -f