FindHao/backup.sh

## backup.sh
#!/usr/bin/env bash
# This script is based on Copyright (C) 2013 - 2020 Teddysun <i@teddysun.com>
# Modified by FindHao <find@findhao.net>

# https://findhao.net/easycoding/2605.html

# You must modify the config before run it!!!


# [[ $EUID -ne 0 ]] && echo "Error: This script must be run as root!" && exit 1

########## START OF CONFIG ##########

# Encrypt flag (true: encrypt, false: not encrypt)
ENCRYPTFLG=true

# WARNING: KEEP THE PASSWORD SAFE!!!
# The password used to encrypt the backup
# To decrypt backups made by this script, run the following command:
# 7z x test.7z -pencrypt_password
BACKUPPASS="encrypt_password"

# Directory to store backups
LOCALDIR="/root/backup/"

# Temporary directory used during backup creation
TEMPDIR="/root/backup/temp/"

# File to log the outcome of backups
LOGFILE="/root/backup/backup.log"

# OPTIONAL: If you want backup MySQL database, enter the MySQL root password below
MYSQL_ROOT_PASSWORD=""

# Below is a list of MySQL database name that will be backed up
# If you want backup ALL databases, leave it blank.
MYSQL_DATABASE_NAME[0]=""

# Below is a list of files and directories that will be backed up in the tar backup
# For example:
# File: /data/www/default/test.tgz
# Directory: /data/www/default/test
BACKUP[0]="/data/www/findhao.net"

# Number of days to store daily local backups (default 7 days)
LOCALAGEDAILIES="14"

# Delete remote file from Googole Drive or FTP server flag (true: delete, false: not delete)
DELETE_REMOTE_FILE_FLG=true

# Rclone remote name
RCLONE_NAME="siteback"

# Rclone remote folder name (default "")
RCLONE_FOLDER="/"

# Baidu Netdisk remote folder name (default "")
BAIDUPAN_FOLDER="/site-backup-rack"

# Use baidupan or rclone
# Options are: baidupan, rclone
BACKUP_EXE="rclone"

# Upload local file to FTP server flag (true: upload, false: not upload)
FTP_FLG=false

# Upload local file to Google Drive flag (true: upload, false: not upload)
RCLONE_FLG=true

# FTP server
# OPTIONAL: If you want upload to FTP server, enter the Hostname or IP address below
FTP_HOST=""

# FTP username
# OPTIONAL: If you want upload to FTP server, enter the FTP username below
FTP_USER=""

# FTP password
# OPTIONAL: If you want upload to FTP server, enter the username's password below
FTP_PASS=""

# FTP server remote folder
# OPTIONAL: If you want upload to FTP server, enter the FTP remote folder below
# For example: public_html
FTP_DIR=""

########## END OF CONFIG ##########

# Date & Time
DAY=$(date +%d)
MONTH=$(date +%m)
YEAR=$(date +%C%y)
BACKUPDATE=$(date +%Y%m%d%H%M%S)
# Backup file name
TARFILE="${LOCALDIR}""$(hostname)"_"${BACKUPDATE}".7z
# Encrypted backup file name
ENC_TARFILE="${TARFILE}.enc"
# Backup MySQL dump file name
SQLFILE="${TEMPDIR}mysql_${BACKUPDATE}.sql"

log() {
    echo "$(date "+%Y-%m-%d %H:%M:%S")" "$1"
    echo -e "$(date "+%Y-%m-%d %H:%M:%S")" "$1" >> ${LOGFILE}
}

# Check for list of mandatory binaries
check_commands() {
    # This section checks for all of the binaries used in the backup
    BINARIES=( cat cd du date dirname echo mysql mysqldump pwd rm tar 7za)
    if [ "${BACKUP_EXE}" == "rclone" ]; then
        BINARIES+=( rclone )
    fi
    if [ "${BACKUP_EXE}" == "baidupan" ]; then
        BINARIES+=( baidupan )
    fi

    # Iterate over the list of binaries, and if one isn't found, abort
    for BINARY in "${BINARIES[@]}"; do
        if [ ! "$(command -v "$BINARY")" ]; then
            log "$BINARY is not installed. Install it and try again"
            exit 1
        fi
    done

    # check rclone command
    RCLONE_COMMAND=false
    if [ "$(command -v "rclone")" ]; then
        RCLONE_COMMAND=true
    fi

    # check ftp command
    if ${FTP_FLG}; then
        if [ ! "$(command -v "ftp")" ]; then
            log "ftp is not installed. Install it and try again"
            exit 1
        fi
    fi
}

calculate_size() {
    local file_name=$1
    local file_size=$(du -h $file_name 2>/dev/null | awk '{print $1}')
    if [ "x${file_size}" = "x" ]; then
        echo "unknown"
    else
        echo "${file_size}"
    fi
}

# Backup MySQL databases
mysql_backup() {
    if [ -z "${MYSQL_ROOT_PASSWORD}" ]; then
        log "MySQL root password not set, MySQL backup skipped"
    else
        log "MySQL dump start"
        mysql -u root -p"${MYSQL_ROOT_PASSWORD}" 2>/dev/null <<EOF
exit
EOF
        if [ $? -ne 0 ]; then
            log "MySQL root password is incorrect. Please check it and try again"
            exit 1
        fi
        if [ "${MYSQL_DATABASE_NAME[*]}" == "" ]; then
            mysqldump -u root -p"${MYSQL_ROOT_PASSWORD}" --all-databases > "${SQLFILE}" 2>/dev/null
            if [ $? -ne 0 ]; then
                log "MySQL all databases backup failed"
                exit 1
            fi
            log "MySQL all databases dump file name: ${SQLFILE}"
            #Add MySQL backup dump file to BACKUP list
            BACKUP=(${BACKUP[*]} ${SQLFILE})
        else
            for db in ${MYSQL_DATABASE_NAME[*]}; do
                unset DBFILE
                DBFILE="${TEMPDIR}${db}_${BACKUPDATE}.sql"
                mysqldump -u root -p"${MYSQL_ROOT_PASSWORD}" ${db} > "${DBFILE}" 2>/dev/null
                if [ $? -ne 0 ]; then
                    log "MySQL database name [${db}] backup failed, please check database name is correct and try again"
                    exit 1
                fi
                log "MySQL database name [${db}] dump file name: ${DBFILE}"
                #Add MySQL backup dump file to BACKUP list
                BACKUP=(${BACKUP[*]} ${DBFILE})
            done
        fi
        log "MySQL dump completed"
    fi
}

start_backup() {
    [ "${BACKUP[*]}" == "" ] && echo "Error: You must to modify the [$(basename $0)] config before run it!" && exit 1

    log "7z backup file start"
#    tar -zcPf ${TARFILE} ${BACKUP[*]}
# mhe entrypt file names
# mmt2 use 2 threads to zip
    7za a -t7z -p${BACKUPPASS} -mhe=on -mmt2 ${TARFILE} ${BACKUP[*]}
    if [ $? -gt 1 ]; then
        log "Tar backup file failed"
        exit 1
    fi
    log "7z backup file completed"

    # Delete MySQL temporary dump file
    for sql in $(ls ${TEMPDIR}*.sql); do
        log "Delete MySQL temporary dump file: ${sql}"
        rm -f ${sql}
    done
    OUT_FILE="${TARFILE}"
    log "File name: ${TARFILE}, File size: $(calculate_size ${TARFILE})"
}

# Transfer backup file to Google Drive
# If you want to install rclone command, please visit website:
# https://rclone.org/downloads/
rclone_upload() {
    if ${RCLONE_FLG} && ${RCLONE_COMMAND}; then
        [ -z "${RCLONE_NAME}" ] && log "Error: RCLONE_NAME can not be empty!" && return 1
        if [ -n "${RCLONE_FOLDER}" ]; then
            rclone ls ${RCLONE_NAME}:${RCLONE_FOLDER} 2>&1 > /dev/null
            if [ $? -ne 0 ]; then
                log "Create the path ${RCLONE_NAME}:${RCLONE_FOLDER}"
                rclone mkdir ${RCLONE_NAME}:${RCLONE_FOLDER}
            fi
        fi
        log "Tranferring backup file: ${OUT_FILE} to Google Drive"
        rclone copy ${OUT_FILE} ${RCLONE_NAME}:${RCLONE_FOLDER} >> ${LOGFILE}
        if [ $? -ne 0 ]; then
            log "Error: Tranferring backup file: ${OUT_FILE} to Google Drive failed"
            return 1
        fi
        log "Tranferring backup file: ${OUT_FILE} to Google Drive completed"
    fi
}
# Transfer backup file to Baidu Netdisk
baidupan_upload(){
    baidupcs-go ls ${BAIDUPAN_FOLDER} 2>&1 > /dev/null
    if [ $? -ne 0 ]; then
        log "Create the path ${BAIDUPAN_FOLDER}"
        baidupcs-go mkdir ${BAIDUPAN_FOLDER}
    fi
    log "Tranferring backup file: ${OUT_FILE} to Baidu Netdisk"
    baidupcs-go upload ${OUT_FILE} ${BAIDUPAN_FOLDER} >> ${LOGFILE}
    if [ $? -ne 0 ]; then
        log "Error: Tranferring backup file: ${OUT_FILE} to Baidu Netdisk failed"
        return 1
    fi
    log "Tranferring backup file: ${OUT_FILE} to Baidu Netdisk completed"
}

# Tranferring backup file to FTP server
ftp_upload() {
    if ${FTP_FLG}; then
        [ -z "${FTP_HOST}" ] && log "Error: FTP_HOST can not be empty!" && return 1
        [ -z "${FTP_USER}" ] && log "Error: FTP_USER can not be empty!" && return 1
        [ -z "${FTP_PASS}" ] && log "Error: FTP_PASS can not be empty!" && return 1
        [ -z "${FTP_DIR}" ] && log "Error: FTP_DIR can not be empty!" && return 1
        local FTP_OUT_FILE=$(basename ${OUT_FILE})
        log "Tranferring backup file: ${FTP_OUT_FILE} to FTP server"
        ftp -in ${FTP_HOST} 2>&1 >> ${LOGFILE} <<EOF
user $FTP_USER $FTP_PASS
binary
lcd $LOCALDIR
cd $FTP_DIR
put $FTP_OUT_FILE
quit
EOF
        if [ $? -ne 0 ]; then
            log "Error: Tranferring backup file: ${FTP_OUT_FILE} to FTP server failed"
            return 1
        fi
        log "Tranferring backup file: ${FTP_OUT_FILE} to FTP server completed"
    fi
}

# Get file date
get_file_date() {
    #Approximate a 30-day month and 365-day year
    DAYS=$(( $((10#${YEAR}*365)) + $((10#${MONTH}*30)) + $((10#${DAY})) ))
    unset FILEYEAR FILEMONTH FILEDAY FILEDAYS FILEAGE
    FILEYEAR=$(echo "$1" | cut -d_ -f2 | cut -c 1-4)
    FILEMONTH=$(echo "$1" | cut -d_ -f2 | cut -c 5-6)
    FILEDAY=$(echo "$1" | cut -d_ -f2 | cut -c 7-8)
    if [[ "${FILEYEAR}" && "${FILEMONTH}" && "${FILEDAY}" ]]; then
        #Approximate a 30-day month and 365-day year
        FILEDAYS=$(( $((10#${FILEYEAR}*365)) + $((10#${FILEMONTH}*30)) + $((10#${FILEDAY})) ))
        FILEAGE=$(( 10#${DAYS} - 10#${FILEDAYS} ))
        return 0
    fi
    return 1
}

# Delete Google Drive's old backup file
delete_gdrive_file() {
    local FILENAME=$1
    if ${DELETE_REMOTE_FILE_FLG} && ${RCLONE_COMMAND}; then
        rclone ls ${RCLONE_NAME}:${RCLONE_FOLDER}/${FILENAME} 2>&1 > /dev/null
        if [ $? -eq 0 ]; then
            rclone delete ${RCLONE_NAME}:${RCLONE_FOLDER}/${FILENAME} >> ${LOGFILE}
            if [ $? -eq 0 ]; then
                log "Google Drive's old backup file: ${FILENAME} has been deleted"
            else
                log "Failed to delete Google Drive's old backup file: ${FILENAME}"
            fi
        else
            log "Google Drive's old backup file: ${FILENAME} is not exist"
        fi
    fi
}

delete_baidupan_file(){
    local FILENAME=$1
    if ${DELETE_REMOTE_FILE_FLG}; then
        baidupcs-go ls ${BAIDUPAN_FOLDER}/${FILENAME} 2>&1 > /dev/null
        if [ $? -eq 0 ]; then
            baidupcs-go rm ${BAIDUPAN_FOLDER}/${FILENAME} >> ${LOGFILE}
            if [ $? -eq 0 ]; then
                log "Baidu Netdisk's old backup file: ${FILENAME} has been deleted"
            else
                log "Failed to delete Baidu Netdisk's old backup file: ${FILENAME}"
            fi
        else
            log "Baidu Netdisk's old backup file: ${FILENAME} is not exist"
        fi
    fi
}


# Transfer backup file to aliyunpan
# Actually, aliyunpan doesn't return the execution status code. Most of the time, the execution status code is 0.
aliyunpan_upload(){
    # if we don't set ALIYUNPAN_FOLDER, just return
    if [ -z "${ALIYUNPAN_FOLDER}" ]; then
        return 0
    fi
    aliyunpan ls ${ALIYUNPAN_FOLDER} 2>&1 > /dev/null
    aliyunpan mkdir ${ALIYUNPAN_FOLDER}
    log "Tranferring backup file: ${OUT_FILE} to aliyunpan"
    aliyunpan upload ${OUT_FILE} ${ALIYUNPAN_FOLDER} >> ${LOGFILE}
    if [ $? -ne 0 ]; then
        log "Error: Tranferring backup file: ${OUT_FILE} to aliyunpan failed"
        return 1
    fi
    log "Tranferring backup file: ${OUT_FILE} to aliyunpan completed"
}

delete_aliyunpan_file(){
    if [ -z "${ALIYUNPAN_FOLDER}" ]; then
        return 0
    fi
    local FILENAME=$1
    if ${DELETE_REMOTE_FILE_FLG}; then
        aliyunpan ls ${ALIYUNPAN_FOLDER}/${FILENAME} 2>&1 > /dev/null
        if [ $? -eq 0 ]; then
            aliyunpan rm ${ALIYUNPAN_FOLDER}/${FILENAME} >> ${LOGFILE}
            if [ $? -eq 0 ]; then
                log "aliyunpan's old backup file: ${FILENAME} has been deleted"
            else
                log "Failed to delete aliyunpan's old backup file: ${FILENAME}"
            fi
        else
            log "aliyunpan's old backup file: ${FILENAME} is not exist"
        fi
    fi
}

# Delete FTP server's old backup file
delete_ftp_file() {
    local FILENAME=$1
    if ${DELETE_REMOTE_FILE_FLG} && ${FTP_FLG}; then
        ftp -in ${FTP_HOST} 2>&1 >> ${LOGFILE} <<EOF
user $FTP_USER $FTP_PASS
cd $FTP_DIR
del $FILENAME
quit
EOF
        if [ $? -eq 0 ]; then
            log "FTP server's old backup file: ${FILENAME} has been deleted"
        else
            log "Failed to delete FTP server's old backup file: ${FILENAME}"
        fi
    fi
}

# Clean up old file
clean_up_files() {
    cd ${LOCALDIR} || exit
    if ${ENCRYPTFLG}; then
        LS=($(ls *.7z))
    else
        LS=($(ls *.tgz))
    fi
    for f in ${LS[@]}; do
        get_file_date ${f}
        if [ $? -eq 0 ]; then
            if [[ ${FILEAGE} -gt ${LOCALAGEDAILIES} ]]; then
                rm -f ${f}
                log "Old backup file name: ${f} has been deleted"
                # check BACKUP_EXE is rclone or baidupan
                if [ "${BACKUP_EXE}" = "rclone" ]; then
                    delete_gdrive_file ${f}
                elif [ "${BACKUP_EXE}" = "baidupan" ]; then
                    delete_baidupan_file ${f}
                fi
                delete_ftp_file ${f}
            fi
        fi
    done
}

# Main progress
STARTTIME=$(date +%s)

# Check if the backup folders exist and are writeable
[ ! -d "${LOCALDIR}" ] && mkdir -p ${LOCALDIR}
[ ! -d "${TEMPDIR}" ] && mkdir -p ${TEMPDIR}

log "Backup progress start"
check_commands
mysql_backup
start_backup
log "Backup progress complete"

log "Upload progress start"
# check BACKUP_EXE is rclone or baidupan
if [ "${BACKUP_EXE}" = "rclone" ]; then
    rclone_upload
elif [ "${BACKUP_EXE}" = "baidupan" ]; then
    baidupan_upload
fi
ftp_upload
log "Upload progress complete"

log "Cleaning up"
clean_up_files
ENDTIME=$(date +%s)
DURATION=$((ENDTIME - STARTTIME))
log "All done"
log "Backup and transfer completed in ${DURATION} seconds"
	#!/usr/bin/env bash
	# This script is based on Copyright (C) 2013 - 2020 Teddysun <i@teddysun.com>
	# Modified by FindHao <find@findhao.net>

	# https://findhao.net/easycoding/2605.html

	# You must modify the config before run it!!!


	# [[ $EUID -ne 0 ]] && echo "Error: This script must be run as root!" && exit 1

	########## START OF CONFIG ##########

	# Encrypt flag (true: encrypt, false: not encrypt)
	ENCRYPTFLG=true

	# WARNING: KEEP THE PASSWORD SAFE!!!
	# The password used to encrypt the backup
	# To decrypt backups made by this script, run the following command:
	# 7z x test.7z -pencrypt_password
	BACKUPPASS="encrypt_password"

	# Directory to store backups
	LOCALDIR="/root/backup/"

	# Temporary directory used during backup creation
	TEMPDIR="/root/backup/temp/"

	# File to log the outcome of backups
	LOGFILE="/root/backup/backup.log"

	# OPTIONAL: If you want backup MySQL database, enter the MySQL root password below
	MYSQL_ROOT_PASSWORD=""

	# Below is a list of MySQL database name that will be backed up
	# If you want backup ALL databases, leave it blank.
	MYSQL_DATABASE_NAME[0]=""

	# Below is a list of files and directories that will be backed up in the tar backup
	# For example:
	# File: /data/www/default/test.tgz
	# Directory: /data/www/default/test
	BACKUP[0]="/data/www/findhao.net"

	# Number of days to store daily local backups (default 7 days)
	LOCALAGEDAILIES="14"

	# Delete remote file from Googole Drive or FTP server flag (true: delete, false: not delete)
	DELETE_REMOTE_FILE_FLG=true

	# Rclone remote name
	RCLONE_NAME="siteback"

	# Rclone remote folder name (default "")
	RCLONE_FOLDER="/"

	# Baidu Netdisk remote folder name (default "")
	BAIDUPAN_FOLDER="/site-backup-rack"

	# Use baidupan or rclone
	# Options are: baidupan, rclone
	BACKUP_EXE="rclone"

	# Upload local file to FTP server flag (true: upload, false: not upload)
	FTP_FLG=false

	# Upload local file to Google Drive flag (true: upload, false: not upload)
	RCLONE_FLG=true

	# FTP server
	# OPTIONAL: If you want upload to FTP server, enter the Hostname or IP address below
	FTP_HOST=""

	# FTP username
	# OPTIONAL: If you want upload to FTP server, enter the FTP username below
	FTP_USER=""

	# FTP password
	# OPTIONAL: If you want upload to FTP server, enter the username's password below
	FTP_PASS=""

	# FTP server remote folder
	# OPTIONAL: If you want upload to FTP server, enter the FTP remote folder below
	# For example: public_html
	FTP_DIR=""

	########## END OF CONFIG ##########

	# Date & Time
	DAY=$(date +%d)
	MONTH=$(date +%m)
	YEAR=$(date +%C%y)
	BACKUPDATE=$(date +%Y%m%d%H%M%S)
	# Backup file name
	TARFILE="${LOCALDIR}""$(hostname)"_"${BACKUPDATE}".7z
	# Encrypted backup file name
	ENC_TARFILE="${TARFILE}.enc"
	# Backup MySQL dump file name
	SQLFILE="${TEMPDIR}mysql_${BACKUPDATE}.sql"

	log() {
	echo "$(date "+%Y-%m-%d %H:%M:%S")" "$1"
	echo -e "$(date "+%Y-%m-%d %H:%M:%S")" "$1" >> ${LOGFILE}
	}

	# Check for list of mandatory binaries
	check_commands() {
	# This section checks for all of the binaries used in the backup
	BINARIES=( cat cd du date dirname echo mysql mysqldump pwd rm tar 7za)
	if [ "${BACKUP_EXE}" == "rclone" ]; then
	BINARIES+=( rclone )
	fi
	if [ "${BACKUP_EXE}" == "baidupan" ]; then
	BINARIES+=( baidupan )
	fi

	# Iterate over the list of binaries, and if one isn't found, abort
	for BINARY in "${BINARIES[@]}"; do
	if [ ! "$(command -v "$BINARY")" ]; then
	log "$BINARY is not installed. Install it and try again"
	exit 1
	fi
	done

	# check rclone command
	RCLONE_COMMAND=false
	if [ "$(command -v "rclone")" ]; then
	RCLONE_COMMAND=true
	fi

	# check ftp command
	if ${FTP_FLG}; then
	if [ ! "$(command -v "ftp")" ]; then
	log "ftp is not installed. Install it and try again"
	exit 1
	fi
	fi
	}

	calculate_size() {
	local file_name=$1
	local file_size=$(du -h $file_name 2>/dev/null \| awk '{print $1}')
	if [ "x${file_size}" = "x" ]; then
	echo "unknown"
	else
	echo "${file_size}"
	fi
	}

	# Backup MySQL databases
	mysql_backup() {
	if [ -z "${MYSQL_ROOT_PASSWORD}" ]; then
	log "MySQL root password not set, MySQL backup skipped"
	else
	log "MySQL dump start"
	mysql -u root -p"${MYSQL_ROOT_PASSWORD}" 2>/dev/null <<EOF
	exit
	EOF
	if [ $? -ne 0 ]; then
	log "MySQL root password is incorrect. Please check it and try again"
	exit 1
	fi
	if [ "${MYSQL_DATABASE_NAME[*]}" == "" ]; then
	mysqldump -u root -p"${MYSQL_ROOT_PASSWORD}" --all-databases > "${SQLFILE}" 2>/dev/null
	if [ $? -ne 0 ]; then
	log "MySQL all databases backup failed"
	exit 1
	fi
	log "MySQL all databases dump file name: ${SQLFILE}"
	#Add MySQL backup dump file to BACKUP list
	BACKUP=(${BACKUP[*]} ${SQLFILE})
	else
	for db in ${MYSQL_DATABASE_NAME[*]}; do
	unset DBFILE
	DBFILE="${TEMPDIR}${db}_${BACKUPDATE}.sql"
	mysqldump -u root -p"${MYSQL_ROOT_PASSWORD}" ${db} > "${DBFILE}" 2>/dev/null
	if [ $? -ne 0 ]; then
	log "MySQL database name [${db}] backup failed, please check database name is correct and try again"
	exit 1
	fi
	log "MySQL database name [${db}] dump file name: ${DBFILE}"
	#Add MySQL backup dump file to BACKUP list
	BACKUP=(${BACKUP[*]} ${DBFILE})
	done
	fi
	log "MySQL dump completed"
	fi
	}

	start_backup() {
	[ "${BACKUP[*]}" == "" ] && echo "Error: You must to modify the [$(basename $0)] config before run it!" && exit 1

	log "7z backup file start"
	# tar -zcPf ${TARFILE} ${BACKUP[*]}
	# mhe entrypt file names
	# mmt2 use 2 threads to zip
	7za a -t7z -p${BACKUPPASS} -mhe=on -mmt2 ${TARFILE} ${BACKUP[*]}
	if [ $? -gt 1 ]; then
	log "Tar backup file failed"
	exit 1
	fi
	log "7z backup file completed"

	# Delete MySQL temporary dump file
	for sql in $(ls ${TEMPDIR}*.sql); do
	log "Delete MySQL temporary dump file: ${sql}"
	rm -f ${sql}
	done
	OUT_FILE="${TARFILE}"
	log "File name: ${TARFILE}, File size: $(calculate_size ${TARFILE})"
	}

	# Transfer backup file to Google Drive
	# If you want to install rclone command, please visit website:
	# https://rclone.org/downloads/
	rclone_upload() {
	if ${RCLONE_FLG} && ${RCLONE_COMMAND}; then
	[ -z "${RCLONE_NAME}" ] && log "Error: RCLONE_NAME can not be empty!" && return 1
	if [ -n "${RCLONE_FOLDER}" ]; then
	rclone ls ${RCLONE_NAME}:${RCLONE_FOLDER} 2>&1 > /dev/null
	if [ $? -ne 0 ]; then
	log "Create the path ${RCLONE_NAME}:${RCLONE_FOLDER}"
	rclone mkdir ${RCLONE_NAME}:${RCLONE_FOLDER}
	fi
	fi
	log "Tranferring backup file: ${OUT_FILE} to Google Drive"
	rclone copy ${OUT_FILE} ${RCLONE_NAME}:${RCLONE_FOLDER} >> ${LOGFILE}
	if [ $? -ne 0 ]; then
	log "Error: Tranferring backup file: ${OUT_FILE} to Google Drive failed"
	return 1
	fi
	log "Tranferring backup file: ${OUT_FILE} to Google Drive completed"
	fi
	}
	# Transfer backup file to Baidu Netdisk
	baidupan_upload(){
	baidupcs-go ls ${BAIDUPAN_FOLDER} 2>&1 > /dev/null
	if [ $? -ne 0 ]; then
	log "Create the path ${BAIDUPAN_FOLDER}"
	baidupcs-go mkdir ${BAIDUPAN_FOLDER}
	fi
	log "Tranferring backup file: ${OUT_FILE} to Baidu Netdisk"
	baidupcs-go upload ${OUT_FILE} ${BAIDUPAN_FOLDER} >> ${LOGFILE}
	if [ $? -ne 0 ]; then
	log "Error: Tranferring backup file: ${OUT_FILE} to Baidu Netdisk failed"
	return 1
	fi
	log "Tranferring backup file: ${OUT_FILE} to Baidu Netdisk completed"
	}

	# Tranferring backup file to FTP server
	ftp_upload() {
	if ${FTP_FLG}; then
	[ -z "${FTP_HOST}" ] && log "Error: FTP_HOST can not be empty!" && return 1
	[ -z "${FTP_USER}" ] && log "Error: FTP_USER can not be empty!" && return 1
	[ -z "${FTP_PASS}" ] && log "Error: FTP_PASS can not be empty!" && return 1
	[ -z "${FTP_DIR}" ] && log "Error: FTP_DIR can not be empty!" && return 1
	local FTP_OUT_FILE=$(basename ${OUT_FILE})
	log "Tranferring backup file: ${FTP_OUT_FILE} to FTP server"
	ftp -in ${FTP_HOST} 2>&1 >> ${LOGFILE} <<EOF
	user $FTP_USER $FTP_PASS
	binary
	lcd $LOCALDIR
	cd $FTP_DIR
	put $FTP_OUT_FILE
	quit
	EOF
	if [ $? -ne 0 ]; then
	log "Error: Tranferring backup file: ${FTP_OUT_FILE} to FTP server failed"
	return 1
	fi
	log "Tranferring backup file: ${FTP_OUT_FILE} to FTP server completed"
	fi
	}

	# Get file date
	get_file_date() {
	#Approximate a 30-day month and 365-day year
	DAYS=$(( $((10#${YEAR}365)) + $((10#${MONTH}30)) + $((10#${DAY})) ))
	unset FILEYEAR FILEMONTH FILEDAY FILEDAYS FILEAGE
	FILEYEAR=$(echo "$1" \| cut -d_ -f2 \| cut -c 1-4)
	FILEMONTH=$(echo "$1" \| cut -d_ -f2 \| cut -c 5-6)
	FILEDAY=$(echo "$1" \| cut -d_ -f2 \| cut -c 7-8)
	if [[ "${FILEYEAR}" && "${FILEMONTH}" && "${FILEDAY}" ]]; then
	#Approximate a 30-day month and 365-day year
	FILEDAYS=$(( $((10#${FILEYEAR}365)) + $((10#${FILEMONTH}30)) + $((10#${FILEDAY})) ))
	FILEAGE=$(( 10#${DAYS} - 10#${FILEDAYS} ))
	return 0
	fi
	return 1
	}

	# Delete Google Drive's old backup file
	delete_gdrive_file() {
	local FILENAME=$1
	if ${DELETE_REMOTE_FILE_FLG} && ${RCLONE_COMMAND}; then
	rclone ls ${RCLONE_NAME}:${RCLONE_FOLDER}/${FILENAME} 2>&1 > /dev/null
	if [ $? -eq 0 ]; then
	rclone delete ${RCLONE_NAME}:${RCLONE_FOLDER}/${FILENAME} >> ${LOGFILE}
	if [ $? -eq 0 ]; then
	log "Google Drive's old backup file: ${FILENAME} has been deleted"
	else
	log "Failed to delete Google Drive's old backup file: ${FILENAME}"
	fi
	else
	log "Google Drive's old backup file: ${FILENAME} is not exist"
	fi
	fi
	}

	delete_baidupan_file(){
	local FILENAME=$1
	if ${DELETE_REMOTE_FILE_FLG}; then
	baidupcs-go ls ${BAIDUPAN_FOLDER}/${FILENAME} 2>&1 > /dev/null
	if [ $? -eq 0 ]; then
	baidupcs-go rm ${BAIDUPAN_FOLDER}/${FILENAME} >> ${LOGFILE}
	if [ $? -eq 0 ]; then
	log "Baidu Netdisk's old backup file: ${FILENAME} has been deleted"
	else
	log "Failed to delete Baidu Netdisk's old backup file: ${FILENAME}"
	fi
	else
	log "Baidu Netdisk's old backup file: ${FILENAME} is not exist"
	fi
	fi
	}


	# Transfer backup file to aliyunpan
	# Actually, aliyunpan doesn't return the execution status code. Most of the time, the execution status code is 0.
	aliyunpan_upload(){
	# if we don't set ALIYUNPAN_FOLDER, just return
	if [ -z "${ALIYUNPAN_FOLDER}" ]; then
	return 0
	fi
	aliyunpan ls ${ALIYUNPAN_FOLDER} 2>&1 > /dev/null
	aliyunpan mkdir ${ALIYUNPAN_FOLDER}
	log "Tranferring backup file: ${OUT_FILE} to aliyunpan"
	aliyunpan upload ${OUT_FILE} ${ALIYUNPAN_FOLDER} >> ${LOGFILE}
	if [ $? -ne 0 ]; then
	log "Error: Tranferring backup file: ${OUT_FILE} to aliyunpan failed"
	return 1
	fi
	log "Tranferring backup file: ${OUT_FILE} to aliyunpan completed"
	}

	delete_aliyunpan_file(){
	if [ -z "${ALIYUNPAN_FOLDER}" ]; then
	return 0
	fi
	local FILENAME=$1
	if ${DELETE_REMOTE_FILE_FLG}; then
	aliyunpan ls ${ALIYUNPAN_FOLDER}/${FILENAME} 2>&1 > /dev/null
	if [ $? -eq 0 ]; then
	aliyunpan rm ${ALIYUNPAN_FOLDER}/${FILENAME} >> ${LOGFILE}
	if [ $? -eq 0 ]; then
	log "aliyunpan's old backup file: ${FILENAME} has been deleted"
	else
	log "Failed to delete aliyunpan's old backup file: ${FILENAME}"
	fi
	else
	log "aliyunpan's old backup file: ${FILENAME} is not exist"
	fi
	fi
	}

	# Delete FTP server's old backup file
	delete_ftp_file() {
	local FILENAME=$1
	if ${DELETE_REMOTE_FILE_FLG} && ${FTP_FLG}; then
	ftp -in ${FTP_HOST} 2>&1 >> ${LOGFILE} <<EOF
	user $FTP_USER $FTP_PASS
	cd $FTP_DIR
	del $FILENAME
	quit
	EOF
	if [ $? -eq 0 ]; then
	log "FTP server's old backup file: ${FILENAME} has been deleted"
	else
	log "Failed to delete FTP server's old backup file: ${FILENAME}"
	fi
	fi
	}

	# Clean up old file
	clean_up_files() {
	cd ${LOCALDIR} \|\| exit
	if ${ENCRYPTFLG}; then
	LS=($(ls *.7z))
	else
	LS=($(ls *.tgz))
	fi
	for f in ${LS[@]}; do
	get_file_date ${f}
	if [ $? -eq 0 ]; then
	if [[ ${FILEAGE} -gt ${LOCALAGEDAILIES} ]]; then
	rm -f ${f}
	log "Old backup file name: ${f} has been deleted"
	# check BACKUP_EXE is rclone or baidupan
	if [ "${BACKUP_EXE}" = "rclone" ]; then
	delete_gdrive_file ${f}
	elif [ "${BACKUP_EXE}" = "baidupan" ]; then
	delete_baidupan_file ${f}
	fi
	delete_ftp_file ${f}
	fi
	fi
	done
	}

	# Main progress
	STARTTIME=$(date +%s)

	# Check if the backup folders exist and are writeable
	[ ! -d "${LOCALDIR}" ] && mkdir -p ${LOCALDIR}
	[ ! -d "${TEMPDIR}" ] && mkdir -p ${TEMPDIR}

	log "Backup progress start"
	check_commands
	mysql_backup
	start_backup
	log "Backup progress complete"

	log "Upload progress start"
	# check BACKUP_EXE is rclone or baidupan
	if [ "${BACKUP_EXE}" = "rclone" ]; then
	rclone_upload
	elif [ "${BACKUP_EXE}" = "baidupan" ]; then
	baidupan_upload
	fi
	ftp_upload
	log "Upload progress complete"

	log "Cleaning up"
	clean_up_files
	ENDTIME=$(date +%s)
	DURATION=$((ENDTIME - STARTTIME))
	log "All done"
	log "Backup and transfer completed in ${DURATION} seconds"