MySQL Backup

@echo off
REM MySQL Dump / Backup Script for Windows NT Systems.
REM
REM This Script will dump all tables from your MySQL Instance to a 7zip archive; 
REM it will Also take care of starting and stopping the MySQL Service on the machine.
REM
 
setlocal
set mysql_username="root"
set mysql_password="password"
set mysql_service="MySQL"
set mysql_path="C:\Program Files\MySQL\MySQL Server 5.5\bin"
set zip_path="C:\Program Files\7-Zip"
set output_path="\\192.168.1.8\server2\Back_Up"
 
 
REM Start of Script.
IF NOT EXIST %output_path% (mkdir %output_path%)
 
REM Check to see if the MySQL Service is running
for /f "tokens=*" %%a IN ('sc query "%mysql_service%" ^| find "RUNNING"') do set servicerunning=%%a
if "X%servicerunning%%" == "X" (goto service_stopped) ELSE (goto service_running)
 
:service_stopped
    echo Starting MySQL Service: %mysql_service%
    net start %mysql_service%
    call :dump_and_zip
    echo Stopping MySQL Service: %mysql_service%
    net stop %mysql_service%
    goto end
 
:service_running
    echo MySQL Service is already running.
    call :dump_and_zip
    goto end
     
:dump_and_zip:
    REM Dump out the MySQL Database to a timestamped.sql file
    for /f "tokens=1,2,3 delims=/ " %%a in ('DATE /T') do set date=%%c-%%b-%%a
    for /f "tokens=1,2 delims=:" %%a in ('TIME /T') do set time=%%a-%%b
    %mysql_path%\mysqldump.exe --user %mysql_username% --password=%mysql_password% --databases ddai > "%output_path%\%date%_%time%.sql"
 
     
:end

Select allOpen in new window