windows脚本备份mysql

@echo off
setlocal

set MYSQL_USER=root
set MYSQL_PASSWORD=your_password
set BACKUP_DIR=C:\backups
set DATE=%date:~-4,4%%date:~-10,2%%date:~-7,2%
set BACKUP_FILE=%BACKUP_DIR%\backup_%DATE%.sql

if not exist %BACKUP_DIR% mkdir %BACKUP_DIR%

mysqldump -u%MYSQL_USER% -p%MYSQL_PASSWORD% --all-databases > %BACKUP_FILE%

echo Backup completed: %BACKUP_FILE%
endlocal

# 安装MySQL模块（如果尚未安装）
# Install-Module -Name MySqlConnector

$MYSQL_USER = "root"
$MYSQL_PASSWORD = "your_password"
$BACKUP_DIR = "C:\backups"
$DATE = Get-Date -Format yyyyMMddHHmmss
$BACKUP_FILE = Join-Path -Path $BACKUP_DIR -ChildPath "backup_$DATE.sql"

if (-Not (Test-Path -Path $BACKUP_DIR)) {
    New-Item -ItemType Directory -Path $BACKUP_DIR | Out-Null
}

Invoke-Expression "mysqldump -u$MYSQL_USER -p$MYSQL_PASSWORD --all-databases > $BACKUP_FILE"

Write-Output "Backup completed: $BACKUP_FILE"