@echo off
(echo set Wshell=CreateObject^("Wscript.Shell"^)
echo wscript.Sleep 2000
echo Wshell.SendKeys "123456{ENTER}"
echo Wshell.SendKeys "")>"%tmp%\inputpassword.vbs"
start "" "%tmp%\inputpassword.vbs"
mysqldump -P 3307 -h localhost -u root -p db1 >D:\database\db1.sql
(echo set Wshell=CreateObject^("Wscript.Shell"^)
echo wscript.Sleep 2000
echo Wshell.SendKeys "123456{ENTER}"
echo Wshell.SendKeys "")>"%tmp%\inputpassword.vbs"
start "" "%tmp%\inputpassword.vbs"
mysqldump -P 3307 -h localhost -u root -p db2>D:\database\db2.sql
(echo set Wshell=CreateObject^("Wscript.Shell"^)
echo wscript.Sleep 2000
echo Wshell.SendKeys "123456{ENTER}"
echo Wshell.SendKeys "")>"%tmp%\inputpassword.vbs"
start "" "%tmp%\inputpassword.vbs"
mysqldump -P 3307 -h localhost -u root -p db3 >D:\database\db3.sql
pause
上面是测试备份mysql的bat,双击运行的时候时可以自动输入密码并且备份的。
但是我放在win7定时任务里面运行,却不能自动输入密码了,请问这是怎么回事!!??