@ECHO OFF
for /f "tokens=1-4 delims=- " %%a in ('date/t') do (
set yy=%%a
set mm=%%b
set dd=%%c
set dw=%%d
)
echo %dw%
echo %mm%
echo %dd%
echo %yy%
SET backupdir=d:\myBackup
SET mysqldir="C:\Program Files\MySQL\MySQL Server 5.1"
SET dbname=mytest
SET dbuser=root
SET dbpasswd=123456
SET filename="%dbname%_%yy%-%mm%-%dd%.sql"
@ECHO Beginning backup of %dbname%...
mysqldump -u %dbuser% -p%dbpasswd% %dbname% >d:\myBackup\%filename%
@ECHO Done!