ssh备份mysql

#!/bin/bash

# 远程服务器信息
REMOTE_USER="your_remote_user"
REMOTE_HOST="your_remote_host"
REMOTE_PORT="your_remote_port"
REMOTE_DIR="/path/to/remote/backup/directory"

# 本地备份目录
LOCAL_DIR="/path/to/local/backup/directory"

# 数据库信息
DB_USER="your_db_user"
DB_PASS="your_db_password"
DB_NAME="your_db_name"

# 备份文件名
BACKUP_FILE="backup_$(date +%Y%m%d%H%M%S).sql"

# 创建本地备份目录
mkdir -p $LOCAL_DIR

# 使用SSH执行远程MySQL备份命令
ssh -p $REMOTE_PORT $REMOTE_USER@$REMOTE_HOST "mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $REMOTE_DIR/$BACKUP_FILE"

# 将备份文件从远程服务器复制到本地
scp -P $REMOTE_PORT $REMOTE_USER@$REMOTE_HOST:$REMOTE_DIR/$BACKUP_FILE $LOCAL_DIR

echo "Backup completed: $LOCAL_DIR/$BACKUP_FILE"