#!/bin/bash

MysqlPath="/opt/databk/week/mysql/"
LdapPath="/opt/databk/week/ldap/"
Path="/opt/databk/"
File_Date=21
Date=`date +"%Y%m%d"`

#备份mysql

/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

tar -czf ${MysqlPath}clbs_week_${Date}.sql.tar.gz ${MysqlPath}clbs_week_${Date}.sql --remove-files

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

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