bat 备份数据库

mysql_backup_tool

@echo off  
setlocal  
  
:: 设置数据库相关信息  
set DATABASE_NAME=cz_svolt_4_phase  
set USERNAME=root  
set PASSWORD=root  
set HOST=localhost  
  
:: 获取当前日期和时间，并格式化为 YYYY-MM-DD_HH-MM-SS  
for /f "tokens=*" %%a in ('powershell -Command "(Get-Date).ToString('yyyy-MM-dd_HH-mm-ss')"') do set TIMESTAMP=%%a  
  
set "TIMESTAMP=%TIMESTAMP: =%"
:: 设置备份文件的完整路径和名称  
set BACKUP_PATH=D:\software\cz_svolt_4_phase_backup_%TIMESTAMP%.sql  
  
:: 执行MySQL备份命令  
echo Backing up %DATABASE_NAME% to %BACKUP_PATH%...  
:: mysqldump -h %HOST% -u %USERNAME% -p%PASSWORD% %DATABASE_NAME% > "%BACKUP_PATH%"  
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" -h %HOST% -u %USERNAME% -p%PASSWORD% %DATABASE_NAME% > "%BACKUP_PATH%"  
  
if %ERRORLEVEL%==0 (  
    echo Backup successful.  
) else (  
    echo Backup failed.  
)  

:: 设置数据库相关信息  
set DATABASE_NAME_cfg_db=cz_svolt_4_phase_cfg_db
:: 设置备份文件的完整路径和名称  
set BACKUP_PATH_cfg_db=D:\software\cz_svolt_4_phase_cfg_db_backup_%TIMESTAMP%.sql  
:: 执行MySQL备份命令  
echo Backing up %DATABASE_NAME_cfg_db% to %BACKUP_PATH_cfg_db%...  
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe" -h %HOST% -u %USERNAME% -p%PASSWORD% %DATABASE_NAME_cfg_db% > "%BACKUP_PATH_cfg_db%"  
  
if %ERRORLEVEL%==0 (  
    echo Backup successful.  
) else (  
    echo Backup failed.  
)  
  
endlocal