Shell and Mysql

[lampakump]

I am trying to run a mysql batch script through the shell. The one
problem though is that the error messages out of my script dont go to
the redirect i.e., if I run

mysql<test.sql>test.log

the error messages do no print into test.log, but to the command line.
I would like to capture the errors into this log file as well. Any
ideas?

Thanks,

Harsha

[SomeDude]

On Sat, 08 Oct 2005 12:25:43 -0700, lampakump wrote:

I am trying to run a mysql batch script through the shell. The one
problem though is that the error messages out of my script dont go to
the redirect i.e., if I run

mysql<test.sql>test.log

the error messages do no print into test.log, but to the command line.
I would like to capture the errors into this log file as well. Any
ideas?

Thanks,

Harsha

In general you can capture all generated output by adding 2>&1 to your
command:

mysql< test.sql > test.log 2>&1

Should do the trick.

SomeDude