docker内zabbix自动备份数据库脚本

#!/bin/bash
db_user="zabbix"       #db的用户名
db_pass="Passwd123."   #db的密码
log='/var/log/mysql_backup.log'   
docker_id=`docker ps -a |  awk '{print $1}'| grep -v "CONTAINER" `

/bin/docker exec -it ${docker_id}  mysqldump -u${db_user} -p${db_pass} --databases zabbix --ignore-table=zabbix.history_uint --ignore-table=zabbix.history   --ignore-table=zabbix.trends_uint   --ignore-table=zabbix.trends  > /home/mysql_backup/zabbix_mysqlbackup.sql_$(date "+%Y-%m-%d)

if [ $? -eq 0 ];then
      echo -e "$(date "+%Y-%m-%d %H:%M:%S")  is finishing backup " >> ${log}
      echo ""
else
     echo -e "$(date "+%Y-%m-%d %H:%M:%S") is failure backup ">> ${log}
fi