#!/bin/bash
# description: MySQL backup shell script
# author : cyberdak
currentTime=$(date +%s)
USER="root"
PASSWORD="123456"
DATABASE="test"
QN_ZONE="zone"
AK="xx"
SK="xx"
BACKUP_DIR=/data/mysql/
LOGFILE=/data/logs/mysql_backup.log
DATE=$(date +%Y%m%d-%H%M)
DUMPFILE=$DATE.sql
ARCHIVE=$DATE.sql.tar.gz
OPTIONS="-u$USER -p$PASSWORD $DATABASE"
if [ ! -d $BACKUP_DIR ]
then
mkdir -p "$BACKUP_DIR"
fi
echo " " >> $LOGFILE
echo "-----------" >> $LOGFILE
echo "BACKUP DATE:" $(date +"%y-%m-%d %H-%M-%s") >> $LOGFILE
echo "-----------" >> $LOGFILE
cd $BACKUP_DIR
mysqldump $OPTIONS >> $DUMPFILE
echo $OPTIONS
if [[ $? == 0 ]]
then
tar czvf $ARCHIVE $DUMPFILE >> $LOGFILE 2>&1
echo "[$ARCHIVE] Backup Successful!" >> $LOGFILE
rm -f $DUMPFILE
/root/qs/qshell account $AK $SK
/root/qs/qshell fput $QN_ZONE $ARCHIVE $BACKUP_DIR/$ARCHIVE
else
echo "Database Backup fail!" >> $LOGFILE
#mail -s "database : $DATABASE Daily Backup Fail!" $MAIL
fi
echo "Backup Process Done"
#Cleaning
find $BACKUP_DIR -type f -mtime +90 -name "*.tar.gz" -exec rm -f "{}" \;
代码如上
执行结果:
Open account file failed, open .qshell/account.json: not a directory Open account file failed, open .qshell/account.json: not a directory, please useaccountto set AccessKey and SecretKey first
github也发了issue了
程序是用来备份的,有人能解答下这个问题吗?
ak,sk你指定了没?报错 “please useaccountto set AccessKey and SecretKey first”