Mysql 自动备份脚本

MySQL自动备份脚本模板

#!/bin/bash
#################################
# copyright by hwb
# DATE:2020-12-03
# 用途：MYSQL备份模板
#################################

#定义
db_host=localhost
db_port=3306
db_name=mysql_prod 
db_user=root
db_pwd=password
backup_path="/data/backup"

# view,function,procedure,event,trigger
output_type='view,function,procedure,event,trigger' 
today=`date +"%Y%m%d-%H%M%S"`
data_file=$backup_path/$db_name$today.sql
object_file="${backup_path}/obj_${db_name}$today.sql"
log_file="/home/scripts/mysql_backup.log"
mysql_cmd="mysql -u${db_user} -p${db_pwd} -h${db_host} -P${db_port} "
mysqldump_cmd="mysqldump -u${db_user} -p${db_pwd} -h${db_host} -P${db_port} $db_name "


#调用函数库
[ -f /etc/init.d/functions ] && source /etc/init.d/functions
export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin
source /etc/profile

#Require root to run this script.
[ $(id -u) -gt 0 ] && echo "请用root用户执行此脚本！" && exit 1


[ -d $backup_path ] || mkdir -p $backup_path


#[ ! -n "$5" ] && echo -e "\033[31m Usage: $0 IP 端口 实例名 用户名 '密码'  \033[0m" && exit 1


function mysql_backup() 
{
   
  echo ""
  echo -e "\033[33m***********************************************mysql数据库备份****************************************************\033[0m" 
  
  echo -e "\033[36m**************备份数据库数据到$data_file**************\033[0m"
  #A p