i have a bat file which does the following:

@echo off
C:\mysql\bin\mysql -u root tms < d:/manish/spooled_files/tms_compliance_trend.sql

basically executes the script file and populates the mysql table

now if incase the process has some errors
i would like to capture the details of the above process in a file

i tried
@echo off
C:\mysql\bin\mysql -u root tms < d:/manish/spooled_files/tms_compliance_trend.sql > path/to/file/output.txt

but it just created an empty file??

help please!!!

You can use --tee=file_name option in the command parameter

C:\mysql\bin\mysql -u root --tee=path/to/file/output.txt tms < d:/manish/spooled_files/tms_compliance_trend.sql

Or use

tee option in your sql file

ok as you said i tried this:

C:\mysql\bin\mysql -u root --tee=d:/manish/output_log/log.txt tms < d:/manish/spooled_files/tms_compliance_trend.sql

i got this message
cant create/write to file d:/manish/output_log/log.txt
errcode = 2

Do u have the directory /manish/output_log/ in your d: drive..?

yeah i got it
but again it creates a blank file ??