MySQL Forums
Forum List  »  General

Re: error logging
Posted by: Shawn Taylor
Date: November 15, 2010 09:11AM

Another approach is mysql --tee.

http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html

MySQL tee only works interactively though.

In a *nix shell, you can take Rick's example one step further

mysql  2>&1 | tee -a j.err

This will send stderr to stdout (let you see the error(s) on screen) and send all of that output to your file.

This is a common mechanism for logging/auditing. Gives you a good place to start when something goes pear shaped.

Good Luck,

Shawn

Options: ReplyQuote


Subject
Written By
Posted
November 09, 2010 12:50PM
November 13, 2010 11:47PM
Re: error logging
November 15, 2010 09:11AM
November 15, 2010 01:53PM
November 16, 2010 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.