Mysql 脚本实例

docker 自动建立数据库

#!/bin/bash
read -p "请您数据数据库密码: " p
read -p "请您数据要创建的数据库: " name

echo "jingyun_${name}0101"
mysql=`docker ps -aqf "name=mysql"`
echo ${mysql}
docker exec -i ${mysql} bash << EOF
mysql -uroot -p$p
create database ${name} character set utf8;
grant all privileges on ${name}.* to $name@'%' identified by "jingyun_${name}0101";
flush privileges;
exit;
EOF

服务器中自动备份数据库

#!/bin/bash
#备份目录
BACKUP=/mydata/backup/db
DATETIME=$(date +%Y-%m-%d_%H%M%S)
echo $DATETIME
#数据库的地址
HOST=localhost
#数据库用户名
DB_USER=root
#数据库密码
DB_PW=hspedu100
#备份的数据库名
DATABASE=hspedu
#创建备份目录，如果不存在，就创建
[ ! -d "${BACKUP}/${DATETIME}" ] && mkdir -p "${BACKUP}/${DATETIME}"
#备份数据库
mysqldump -u${DB_USER} -p$(DB_PW} --host=$(HOST} -q -R --databases $(DATABASE} | gzip > $(BACKUP}/$(DATETIME}/$DATETIME.sql.gz

#将文件处理成 tar.gz
cd ${BACKUP}
tar -zcvf $DATETIME.tar.gz ${DATETIME}
#删除对应的备份目录
rm -rf ${BACKUP}/${DATETIME}
#删除10天前备份文件
find ${BACKUP} -atime +10 -name "*.tar.gz" -exec rm {} \;
echo "备份数据库${DATABASE} 成功----"

Replace_yum_centos7

#!/bin/bash

# 提示用户输入
echo "欢迎使用centos7一键更换阿里yum源脚本"
read -p "你想继续执行吗? (y/n): " answer

# 检查用户输入是否为y或Y
if [[ "$answer" == "y" ]] || [[ "$answer" == "Y" ]]; then
    echo "下载阿里yum源"
    sleep 2
    cd /etc/yum.repos.d
    curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
    echo "完毕 开始清理缓存"
    sleep 2
    yum clean all
    echo "完毕 开始生成新源缓存"
    sleep 2
    yum makecache
    echo "完毕 开始下载epel库"
    sleep 2
    yum install -y epel-release
    echo "完毕 重新执行上述"
    sleep 2
    yum clean all
    yum makecache
    echo "完毕"
else
    echo "用户取消执行。"
    exit 1
fi