Windows 2008 Server Standard SP2 64-bit.
I have a batch file scheduled to run every day that unzips a file and imports the data into a MySQL database on the same server. The file unzips properly but will not import the data. The mysql command runs for about 30 seconds and then the task ends like it completed successfully. No errors in event log or any screen output. It works fine if I manually execute the batch file, but not from task scheduler. Here is the command that will not execute properly when scheduled:
mysql -h 192.168.15.7 -u user -ppassword -P4928 database < "d:\folder\file.sql"
The task scheduler log shows event 102 Task Completed op code (2) and event 201 Action Completed return code 0 op code (2). The task is set to run using a local administrator account and is set to run whether user is logged in or not.
Please help. Thanks!