@echo off set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%" "C:/Program Files (x86)/MySQL/MySQL Server 5.5/bin/mysqldump.exe" --opt -hlocalhost -uroot -proot skcms > D:\db_backup\skcms_%Ymd%.sql cmd