BASH & MYSQL - logg mysql problems during running of a bash/sh script

Question

I am building a bash script that makes a lot of use of mysql. Now I want to add it a possibility to log down any comments/errors that come from the database. lets admit the simple case.

mysql -uuser -ppass dbase <<EOF
insert into table (col) values ("$val");
EOF

how would this look with logging to /var/log/mylamescript ? I want to log warnings, errors, etc ... anything except "successful"

I do not want to log the transactions, I want to log errors and warnings regarding the transactions. — user1986815
– user1986815, Commented May 9, 2013 at 12:24

toro2k · Accepted Answer · 2013-05-09 13:16:27Z

1

You just have to redirect the standard error appending to your log file:

mysql -uuser -ppass dbase <<EOF 2>> /var/log/mylamescript 
    insert into table (col) values ("$val");
EOF

edited May 9, 2013 at 13:16

answered May 9, 2013 at 12:33

toro2k

19.3k8 gold badges66 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1986815 Over a year ago

I was trying to see what mysql --debug is saying, but I get mysql: ERROR: Option 'debug' used, but is disabled

toro2k Over a year ago

@eichertc 2>> means appending the standard error to a file. MySQL emits both errors and warnings on the standard error. Regarding the --debug option you need a debug enabled MySQL (you can configure it during compilation). Check also --debug-info.

Collectives™ on Stack Overflow

BASH & MYSQL - logg mysql problems during running of a bash/sh script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related