How to Log Warnings and Errors from queries

2006-03-09 Thread ryan lwf
Hi all, I understand that the option log-errors and log-warnings only logs server related internal errors. How do I enable logging errors from queries executed, so that I can fix the problematic query statement accordingly? The statement "SHOW WARNINGS" and "SHOW ERRORS" does not work on my serv

Re: How to Log Warnings and Errors from queries

2006-03-10 Thread ryan lwf
Hi Dan, Noted with thanks. As such, is there a workaround to log problematic sql queries ran against the mysqld server ? Do I need to write separate script to do this ? Regards, Ryan. On 3/10/06, Dan Nelson <[EMAIL PROTECTED]> wrote: > > In the last episode (Mar 08), ryan lwf

Re: How to Log Warnings and Errors from queries

2006-03-13 Thread ryan lwf
ery(...) will log all mysql errors into a file. and you may > provide an web-interface (assuming this is a web application) to > view/download the log files. > > Regards, > Rithish. > > > > -Original Message- > From: ryan lwf [mailto:[EMAIL PROTECTED] > Se