@echo off
if not exist "F:\dumps\MySQL_%date:~0,4%_%date:~5,2%%date:~8,2%\" md "F:\dumps\MySQL_%date:~0,4%_%date:~5,2%%date:~8,2%\"
set mysqldumpDir=E:\acquia-drupal\mysql\bin\mysqldump
set backupDir=F:\dumps\MySQL_%date:~0,4%_%date:~5,2%%date:~8,2%\
set zipDir="D:\Program Files\7-Zip\7z.exe"
set bakFileNameTail=_%date:~0,4%_%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%
set databaseName=aorder,booking,ck2,cosmotology,cosmowhite,dphoto,order,photo_v3,vital
for %%d in (%databaseName%) do (
%mysqldumpDir% -uroot -p123456 --default-character-set=utf8 --opt --extended-insert=false --triggers -R --hex-blob -x %%d > %backupDir%%%d%bakFileNameTail%.sql
%zipDir% a -tzip %backupDir%%%d%bakFileNameTail%.zip %backupDir%%%d%bakFileNameTail%.sql
del %backupDir%%%d%bakFileNameTail%.sql
)
echo "OK!"
pause