网站如何上传数据库

import subprocess
import datetime

# 数据库配置
db_host = 'localhost'
db_user = 'root'
db_pass = 'password'
db_name = 'mydatabase'

# 备份文件名
backup_file = f"{db_name}_{datetime.datetime.now().strftime('%Y%m%d%H%M%S')}.sql"

# 备份数据库
backup_command = f"mysqldump -h {db_host} -u {db_user} -p{db_pass} {db_name} > {backup_file}"
subprocess.run(backup_command, shell=True, check=True)

# 上传备份文件到远程服务器
remote_host = 'remote_server_ip'
remote_user = 'remote_user'
remote_path = '/path/to/remote/directory/'

upload_command = f"scp {backup_file} {remote_user}@{remote_host}:{remote_path}"
subprocess.run(upload_command, shell=True, check=True)

print(f"Database backup uploaded successfully to {remote_host}:{remote_path}")