#!/bin/bash
#作者:comyn 2020-04-01
#用于数据库备份
#备份路径
backup_path=/data1/backup/`date +%Y%m%d`;
#mysql参数
mysql_port=3306
mysql_host=127.0.0.1
mysql_user=root
mysql_pwd=123456
mysql_db=test
mysql_backup_file=test.sql
# 创建备份文件夹
echo "备份路径:$backup_path"
if [ -d $backup_path ];then
echo “路径已存在”;
else
mkdir -p $backup_path;
if [ $? -eq 0 ];then
echo "$backup_path 创建成功";
else
echo "$backup_path 创建失败,请检查!";
fi
fi
# mysql备份命令
echo -e "\033[32m开始备份$backup_path/$mysql_backup_file\033[0m"
mysqldump --defaults-extra-file=/etc/mysql/my.cnf -h$mysql_host -p$mysql_port -u$mysql_user -p$mysql_pwd --databases $mysql_db > $backup_path/$mysql_backup_file
if [ $? -eq 0 ];then
echo "备份成功,备份文件为:$backup_path/$mysql_backup_file";
else
echo "备份失败,请检查!";
echo "备份命令:mysqldump --defaults-extra-file=/etc/mysql/my.cnf -h$mysql_host -p$mysql_port -u$mysql_user -p$mysql_pwd --databases $mysql_db > $backup_path/$mysql_backup_file"
fi
执行结果: