Re: error logging

[Rick James]

Redirect STDERR:
Windows example:

C:\Users\rj>mysql  2>j.err
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 424
Server version: 5.1.30-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from non-table;
mysql> exit
Bye

C:\Users\rj>more j.err
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-table' at line 1
C:\Users\rj>

The "2>filename" should work in most *nix shells, too.