#!/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:~/" fielse echo "Failed to export database"fi