Catching mysql errors in bourne shell

Geneset · 04-05-2009, 12:29 PM

Hi guys, quick one today.

I am writing a logging function for my script library with functions like logger_error, logger_info, logger_debug and logger_trace.

I have a script that automated some mysql transactions across a few servers where due to changes in configuration, i get errors.

Basically, i want to not change where stdout goes (currently it goes to logger_info) and pipe stderr to logger_error.

Redirections dont work.

Have googled endlessly for stderr piping and got some really good attempts but none seem to work for the mysql client.

A bash example would be acceptable but i would prefer a posix or bourne example.

Has anyone come across this before that can gimme a hand? Many regards
G

Robhogg · 04-05-2009, 02:08 PM

Quote:

Originally Posted by Geneset

Redirections dont work.

How are you trying to do the redirection? In order to redirect stderr, you use its file descriptor (2) - a very simple example:

Code:

rob:~$ mysql -uusername -p <<-EOF 2>>mysql.err 1>>mysql.out
> select * from testdb.contacts;
> select * from testdb.nosuchtable;
> EOF
Enter password:
rob:~$ cat mysql.out
name	telephone	appid
Rob	09876 123456	1
Carol	01274 245326	NULL
Jeremy	0895 123456	NULL
John	0116 7891234	1
rob:~$ cat mysql.err
ERROR 1146 (42S02) at line 2: Table 'testdb.nosuchtable' doesn't exist 
rob:~$