@echo off & setlocal

echo.
echo MySQL Data Backup
echo *****************************
echo.

@echo off
>"%temp%\MyDate.vbs" echo dt=date()
>>"%temp%\MyDate.vbs" echo s=right(year(dt),4) ^& "-" ^& right("0" ^& month(dt),2) ^& "-" ^& right("0" ^& day(dt),2)
>>"%temp%\MyDate.vbs" echo wscript.echo s
for /f %%a in ('cscript /nologo "%temp%\MyDate.vbs"') do set Today=%%a
echo Today is %Today%

echo *********************************************
pause

cd ../
If not exist backup MD backup
cd db/bin
echo Backup default now and it will take several minutes, please wait...
mysqldump -uroot -proot -P3307 --opt --databases bb2_default bb2_default_sg bb2_def --skip-lock-tables --hex-blob>../../backup/%Today%.sql 
if errorlevel 1 (
    echo 备份数据失败，可能没有开启服务器，或者是更改了数据库端口或密码,请按任意键退出
    pause>null
    exit
) 
cd ../../backup
makecab %Today%.sql %Today%.sql.zip
del %Today%.sql
cd ../
echo.
pause