利用shell脚本去备份所指定的数据库
发布时间：2020-12-15 21:12:37 所属栏目：安全 来源：网络整理
导读：#! /bin/bash logintool=/home/yx/server/mysql/mysql/bin/mysql dumptool=/home/yx/server/mysql/mysql/bin/mysqldump username=root passwd=`cat /home/yx/stt/shellmysql/dumpsql/.passwd` socketfile=/var/run/mysqld/mysqld.sock storepath=/home/yx/ba
#! /bin/bash logintool=/home/yx/server/mysql/mysql/bin/mysql dumptool=/home/yx/server/mysql/mysql/bin/mysqldump username=root passwd=`cat /home/yx/stt/shellmysql/dumpsql/.passwd` socketfile=/var/run/mysqld/mysqld.sock storepath=/home/yx/backup/hnf_file now=`date +%Y%m%d%H%M%S` password=${passwd} stty erase ‘^H‘ read -p "请输入库名：" dbname if [[ -z ${dbname} ]];then echo -e "你输出的库名为空，请输入库名！n" exit 100 else dbcheck=`${logintool} -u ${username} -p${password} -e "show databases;" 2>/dev/null | grep -w "${dbname}"` if [[ -z ${dbcheck} ]];then echo -e "你要导出的库不存在！请重新输入正确的dbname！n" exit 100 fi fi ${dumptool} -u ${username} -p${password} -S ${socketfile} --set-gtid-purged=off ${dbname} > ${storepath}/${dbname}-${now}.sql echo -e "${dbname}库 已经备份完毕!n" echo "保存路径为：${storepath}/${dbname}-${now}.sql"``
然后执行这个脚本，会提示你输入想要备份的数据库
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
