Thread: Calling .bat file problem...

I wrote a script to backup some files for me automagically and to also call a .bat file that would backup my MySQL database.

Well, the file copying works great, but for some reason, it doesn't call the .bat file like it's supposed to. When I run the script manually, it works exactly as it should, but when it runs at 1 AM like I asked, it borks.

Here's the vbs:

Code:

dim dbcopy
dim mysqlbackup
dim foldername

foldername="C:\backup\"&weekdayname(weekday(date()))
set dbcopy=CreateObject("Scripting.FileSystemObject")
if dbcopy.FolderExists(foldername) then
  dbcopy.DeleteFolder(foldername)
end if
dbcopy.CreateFolder(foldername)
dbcopy.CopyFile "C:\Inetpub\wwwroot\_private\*.*", foldername

set mysqlbackup=wscript.createobject("wscript.shell")
mysqlbackup.run("sqlbackup.bat "&weekdayname(weekday(date())))

And here's the contents of 'sqlbackup.bat':

Code:

@echo on
mysqldump -uxxx -pxxx sales > c:\backup\%1\sales.sql

As always, any assistance is greatly appreciated.

That's actually the same page I read when I wrote the script. As I said, the script runs flawlessly when I run it manually. I did, however, just add the full path to mysqlbackup.bat and scheduled it to run a couple minutes ago and it worked. So I guess the lesson here is, "Don't trust the computer to know where all the files are, even if they are in the same directory."

Thank you, Murray!