如何用bat脚本+mysqldump进行mysql的数据库备份

@echo off

set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"
C:\MySQL\bin\mysqldump --opt -u root --password=123456 bbs > D:\dbbackup\bbs%Ymd%.sql
@echo on