回复 7# lazygc520 - @echo off
- rem 设置MySQL用户名
- set username=MYUSER
- rem 设置MySQL密码
- set password=MYPASS
- >"%tmp%\MyDel.vbs" echo dt=date()-1
- >>"%tmp%\MyDel.vbs" echo s=right(year(dt),4) ^& right("0" ^& month(dt),2) ^& right("0" ^& day(dt),2)
- >>"%tmp%\MyDel.vbs" echo wscript.echo s
- for /f %%a in ('cscript /nologo "%tmp%\MyDel.vbs"') do set yesterday=%%a
- echo %yesterday%
- cd /d "C:\Program Files\MySQL\MySQL Server 5.1\bin\"
- mysqldump -u%username% -p%password% <"E:\software install\testDatabaseBackup\cvtbarcode%yesterday%test.sql"
复制代码
|