自动备份数据库脚本

最新推荐文章于 2024-08-01 15:48:01 发布

DCHXMJ

最新推荐文章于 2024-08-01 15:48:01 发布

阅读量306

点赞数

文章标签：脚本

本文链接：https://blog.csdn.net/DCHXMJ/article/details/61207220

版权

自动备份数据库

#!/bin/bash
read -p "Please enter username:" USER
read -p "Passwd:" -s PASSWD
mysql -u$USER -p$PASSWD -e "SHOW DATABASES;" &>/dev/null
if [ "$?" != "0" ]
then 
    echo -e "\nwhat you written is wrong"
    exit
else    
    mysql -u$USER -p$PASSWD -e "SHOWDATABASES;"  #用user用户登录，密码是passwd
    read -p "Please enter the file what you want to copy:"  DBNAME 
    read -p "Please give a path（/XXX/XXX.sql）:"  DCH   

mysqldump -u$USER -p$PASSWD $DBNAME > $DCH
fi
if [ "$?" = "0" ]
then
    echo "finished"
else
    echo "fail"
fi