nt: Friday, March 10, 2006 8:14 PM
> To: Dan Nelson
> Cc: mysql@lists.mysql.com
> Subject: Re: How to Log Warnings and Errors from queries
>
>
> Hi Dan,
>
> Noted with thanks.
>
> As such, is there a workaround to log problematic sql queries ran against
> the mysqld se
: ryan lwf [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 8:14 PM
To: Dan Nelson
Cc: mysql@lists.mysql.com
Subject: Re: How to Log Warnings and Errors from queries
Hi Dan,
Noted with thanks.
As such, is there a workaround to log problematic sql queries ran against
the mysqld server ? Do
sql"));
Regards!
Edwin.
-Mensaje original-
De: Subscriptions [mailto:[EMAIL PROTECTED]
Enviado el: Viernes, 10 de Marzo de 2006 10:27 a.m.
Para: mysql@lists.mysql.com
Asunto: Re: How to Log Warnings and Errors from queries
In PHP, you can see the error message as follows:
$resu
(mysql_error()) );
where you create that function log_error to write to a file.
Jenifer
- Original Message -
From: "Kishore Jalleda" <[EMAIL PROTECTED]>
To: "ryan lwf" <[EMAIL PROTECTED]>
Cc: "Dan Nelson" <[EMAIL PROTECTED]>;
Sent: Fr
as you know mysql gives you an error to check your sql syntax when it
doesn't understand a query but does not log it , but you can have your
application (php, perl, etc ) accessing mysql to log any bad/malformed
queries...
Kishore Jalleda
On 3/10/06, ryan lwf <[EMAIL PROTECTED]> wrote:
> Hi Dan
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 said:
> > I unde
In the last episode (Mar 08), ryan lwf said:
> 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 WARN
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
