windows脚本备份mysql数据库

@echo off
setlocal

:: 设置MySQL连接信息
set MYSQL_USER=root
set MYSQL_PASSWORD=your_password
set MYSQL_DATABASE=your_database
set BACKUP_DIR=C:\backups

:: 创建备份目录
if not exist %BACKUP_DIR% mkdir %BACKUP_DIR%

:: 执行备份
mysqldump -u%MYSQL_USER% -p%MYSQL_PASSWORD% %MYSQL_DATABASE% > %BACKUP_DIR%\backup_%date:~-4,4%%date:~-10,2%%date:~-7,2%.sql

echo Backup completed successfully!

endlocal

# 设置MySQL连接信息
$MYSQL_USER = "root"
$MYSQL_PASSWORD = "your_password"
$MYSQL_DATABASE = "your_database"
$BACKUP_DIR = "C:\backups"

# 创建备份目录
if (-Not (Test-Path $BACKUP_DIR)) {
    New-Item -ItemType Directory -Path $BACKUP_DIR
}

# 执行备份
$backup_file = Join-Path -Path $BACKUP_DIR -ChildPath "backup_$(Get-Date -Format 'yyyyMMddHHmmss').sql"
mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE > $backup_file

Write-Output "Backup completed successfully: $backup_file"