,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
>
>>-Original Message-
>>From: Anirudh Sundar [mailto:sundar.anir...@gmail.com]
>>Sent
log working if
possible as it sounds pretty useful, so thanks again.
Bill
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: 09 June 2010 16:43
To: 'Anirudh Sundar'; mysql@lists.mysql.com
Subject: RE: How can I see the query from a remote session against my s
om: Anirudh Sundar [mailto:sundar.anir...@gmail.com]
>Sent: Wednesday, June 09, 2010 9:47 AM
>To: mysql@lists.mysql.com
>Subject: Re: How can I see the query from a remote session against my server
>
>Michael is right. But sometimes General log is not enabled and if that is
>the case th
binlogs only contain data modifications, it won't show you the SELECT
queries; I don't think that path is worth your time for the problem at
hand. I suggest you explicitly enable the gebneral query log and
restart if need be.
- md
On Wed, Jun 9, 2010 at 9:47 AM, Anirudh Sundar wrote:
> Michael
Michael is right. But sometimes General log is not enabled and if that is
the case then you need to refer to the "Binary" logs.
But you cannot read the contents of the binlog just like that. You need to
convert that to a readable format.
mysqlbinlog bin.10001 > /tmp/read_bincontent.log
Cheers,
A
You have 2 options here. The Mysql General Query Log
http://dev.mysql.com/doc/refman/5.1/en/query-log.html
Alternatively, if it's windows ( I ask because of the ODBC connector)
and it's easier for you,
I haven't done windows in awhile, but I suspect you might find what
you want via that connecto
