Simple MySQL server backup DATABASE batch

IOF>>
@ECHO OFF
SET SUSER=backup_www
SET SPASSWD=XXXXXX
rem date?
FOR /F “TOKENS=2-4 DELIMS=/ ” %%A IN (‘DATE /T’) DO (SET date=%%B%%A%%C)
rem db? filename?
SET db=dbname
SET filename_db=%db%_db_%date%.bak
del F:\BACKUP\server.domain\MySQL\%filename_db%.rar
mysqldump -u %SUSER% -p%SPASSWD% –complete-insert –default-character-set=utf8 %db% > F:\Backup\MySQL\%filename%
rar a -m3 -v1G -vn F:\BACKUP\server.domain\MySQL\%filename_db%.rar F:\BACKUP\server.domain\MySQL\%filename_db%
del F:\BACKUP\server.domain\MySQL\%filename_db%
<<EOF

Simple Microsoft MsSQL server backup DATABASE & LOG batch

IOF>>

@ECHO OFF
SET SUSER=backup_www
SET SPASSWD=XXXXXX

rem date?
FOR /F “TOKENS=2-4 DELIMS=/ ” %%A IN (‘DATE /T’) DO (SET date=%%B%%A%%C)

rem db? filename?

SET db=dbname

SET filename_db=%db%_db_%date%.bak

SET filename_log=%db%_log_%date%.bak

del F:\BACKUP\server.domain\MSSQL\%filename_db%.rar

del F:\BACKUP\server.domain\MSSQL\%filename_log%.rar

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP DATABASE [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_db%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_db%.rar F:\BACKUP\server.domain\MSSQL\%filename_db%
del F:\BACKUP\server.domain\MSSQL\%filename_db%

OSQL -U%SUSER% -P%SPASSWD% -D server.domain -n -Q “BACKUP LOG [dbname] TO DISK = ‘\\machine.domain\F$\BACKUP\server.domain\MSSQL\%filename_log%’”

rar a -m3 -v1G -vn F:\BACKUP\server.domain\MSSQL\%filename_log%.rar F:\BACKUP\server.domain\MSSQL\%filename_log%
del F:\BACKUP\server.domain\MSSQL\%filename_log%

Start | Stop Windows 7 Firewall batch

Start IT:

IOF>>

@echo off

netsh firewall set opmode mode=ENABLE exceptions=DISABLE profile=CURRENT
netsh firewall set opmode mode=ENABLE exceptions=DISABLE profile=DOMAIN
netsh firewall set opmode mode=ENABLE exceptions=DISABLE profile=STANDARD

<<EOF

Stop IT:

IOF>>

@echo off

netsh firewall set opmode mode=DISABLE exceptions=DISABLE profile=CURRENT
netsh firewall set opmode mode=DISABLE exceptions=DISABLE profile=DOMAIN
netsh firewall set opmode mode=DISABLE exceptions=DISABLE profile=STANDARD

<<EOF