#!/bin/bash

# 数据库信息
db_user="your_db_user"
db_password="your_db_password"
db_name="your_database_name"

# 本地临时目录
local_temp_dir="/tmp"

# 远程服务器信息
remote_server="127.0.0.1"
remote_user="root"

# 导出数据库文件名
backup_file="$db_name-$(date +'%Y-%m-%d').sql"

# 导出数据库
mysqldump -u "$db_user" -p"$db_password" "$db_name" > "$local_temp_dir/$backup_file"

# 检查导出是否成功
if [ $? -eq 0 ]; then
echo "Database exported successfully to $local_temp_dir/$backup_file"

# 复制文件到远程服务器
scp "$local_temp_dir/$backup_file" "$remote_user@$remote_server:~/"

# 检查复制是否成功
if [ $? -eq 0 ]; then
echo "File copied successfully to $remote_user@$remote_server:~/"
else
echo "Failed to copy file to $remote_user@$remote_server:~/"
fi
else
echo "Failed to export database"
fi