payroll/backup/执行备份.bat

@echo off
chcp 65001 >nul
echo ========================================
echo 工资发放管理系统数据库备份脚本
echo 备份日期: 2025-12-26
echo ========================================
echo.

REM 设置备份目录
set BACKUP_DIR=e:\hadooptools\hadoop_pakeage\sources\payrollsystem\backup
set BACKUP_DATE=20251226

echo 正在备份数据库...
echo.

REM 完整备份(需要MySQL已配置到环境变量)
mysqldump -h localhost -u root -proot payroll_system > "%BACKUP_DIR%\backup_payroll_system_%BACKUP_DATE%_full.sql"

if %errorlevel% == 0 (
    echo [成功] 数据库完整备份已完成
    echo 备份文件: backup_payroll_system_%BACKUP_DATE%_full.sql
) else (
    echo [失败] 数据库备份失败,请检查:
    echo 1. MySQL是否已安装并配置到环境变量
    echo 2. MySQL服务是否正在运行
    echo 3. 用户名和密码是否正确
)

echo.
echo 按任意键退出...
pause >nul