BASH:备份MySQL数据库并通过FTP发送到远程服务器

#!/bin/bash

# 定义数据库信息
DB_HOST="localhost"
DB_USER="username"
DB_PASS="password"
DB_NAME="database_name"

# 定义备份文件名和路径
BACKUP_DIR="/path/to/backup"
BACKUP_FILE="${BACKUP_DIR}/$(date +%Y%m%d%H%M%S).sql"

# 备份数据库
mysqldump -h ${DB_HOST} -u ${DB_USER} -p${DB_PASS} ${DB_NAME} > ${BACKUP_FILE}

# 通过FTP发送备份文件到远程服务器
FTP_HOST="ftp.example.com"
FTP_USER="ftp_username"
FTP_PASS="ftp_password"
FTP_DIR="/path/to/remote/directory"

ftp -n ${FTP_HOST} <<END_SCRIPT
quote USER ${FTP_USER}
quote PASS ${FTP_PASS}
cd ${FTP_DIR}
put ${BACKUP_FILE}
quit
END_SCRIPT

# 删除本地备份文件
rm ${BACKUP_FILE}