- 今天我写了一个shell脚本备份我的mysql,结果死活没用
#by authors ach 2019
#define backup path
BAKDIR=/reasch/`date +%Y%m%d`
MYSQLDB=mysite
MYSQLUSR=backup
MYSQLPW=123456
MYSQLCMD=/usr/bin/mysqldump
sudo -i
if [ ! -d $BAKDIR ];then
sudo mkdir -p $BAKDIR
echo -e "\033[32mthe $BAKDIR create successfully\033[0m"
else
echo "this $BAKDIR is exists..."
fi
# mysql backup command
sudo $MYSQLCMD -u$MYSQLUSR -p$MYSQLPW -d $MYSQLDB > $BAKDIR/$MYSQLDB.sql
if [ $? -eq 0 ];then
echo -e "\033[32mthe mysql backup $MYSQLDB successful\033[0m"
else
echo "please check."
fi
- 遇到的问题稀奇古怪,这里就不一一细说了,总之,劝解大家,写好代码,一定要看清楚,有些是必须是root用户才能执行的,即使你用了sudo等强制性也没用,因为用户还是普通用户