mysql 计划任务 启动失败_任务计划执行失败，什么原因？

任务计划执行了，但是里面任务没有执行成功，请大家帮我看看！下面是批处理文件GameDB0629(partial)2.bat文件内容：@echooffsetserver_filename=D:\dbdbdbdbdb\gamedb0613_%date:~0,4...

任务计划执行了，但是里面任务没有执行成功，请大家帮我看看！

下面是批处理文件GameDB0629(partial)2.bat文件内容：

@echo off

set server_filename=D:\dbdbdbdbdb\gamedb0613_%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%"

set struct=%server_filename%(struct).sql

set all=%server_filename%(all).sql

set part=%server_filename%.sql

set players=%server_filename%_players.sql

set accounts=%server_filename%_accounts.sql

"C:\Program Files\MySQL\MySQL Server 5.1"\bin\mysqldump -R --opt -u root --password=123 --default-character-set=UTF8 gamedb0613 -d> %struct%

"C:\Program Files\MySQL\MySQL Server 5.1"\bin\mysqldump -R --opt -u root --password=123 --default-character-set=UTF8 gamedb0613 > %all%

"C:\Program Files\MySQL\MySQL Server 5.1"\bin\mysqldump -R --opt -u root --password=123 --default-character-set=UTF8 gamedb0613 awardtemplate creaturetemplate door gift itemtemplate lootkey lootshop mall map maptemplate monster npc_table npctransmit quest questionstemplate shop spelltemplate> %part%

"C:\Program Files\MySQL\MySQL Server 5.1"\bin\mysqldump -R --opt -u root --password=123456 --default-character-set=UTF8 gamedb0613 players > %players%

"C:\Program Files\MySQL\MySQL Server 5.1"\bin\mysqldump -R --opt -u root --password=123456 --default-character-set=UTF8 gamedb0613 accounts > %accounts%

下面是执行日志：

"GameDB0629(partial)2.job" (GameDB0629(partial)2.bat)

Finished 6/30/2010 6:37:50 PM

Result: The task completed with an exit code of (1).

"GameDB0629(partial)2.job" (GameDB0629(partial)2.bat)

Started 6/30/2010 6:38:00 PM

"GameDB0629(partial)2.job" (GameDB0629(partial)2.bat)

Finished 6/30/2010 6:38:00 PM

Result: The task completed with an exit code of (1).

最后我要让它自动备份数据库失败，没有自动导出sql文件！

知道的告诉我！谢谢！

附加：该bat文件直接双击能正确执行，做成任务计划就不能完成任务！

展开