@echo off  

SET dateY=%date:~0,4%

SET dateM=%date:~5,2%

SET dateD=%date:~8,2%

SET time2=%time: =0%

SET timeH=%time2:~0,2%

SET timeM=%time2:~3,2%

SET timeS=%time2:~6,2%

SET filename=%dateY%%dateM%%dateD%_%timeH%%timeM%%timeS%

SET dbfilename=tbl_nua2_db

mysqldump -uroot -p1111 %dbfilename% > E:\autodb\%dbfilename%_%filename%.sql