How to capture MySQL queries sent to server?

How to capture MySQL queries sent to server?

am 16.05.2009 00:08:50 von mos

I'm running Windows XP and I'd like to capture the SQL commands that are
sent to the MySQL server. Is there a way to do this on Windows?

TIA
Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: How to capture MySQL queries sent to server?

am 16.05.2009 00:40:26 von Rolando Edwards

Turn On General Logging

In my.ini insert this option in the [mysqld] section

log=3DC:\MySQLLogging.txt

and restart mysql

Rolando A. Edwards
MySQL DBA (CMDBA)

155 Avenue of the Americas, Fifth Floor
New York, NY 10013
212-625-5307 (Work)
201-660-3221 (Cell)
AIM : RolandoLogicWorx
Skype : RolandoLogicWorx
redwards@logicworks.net

-----Original Message-----
From: mos [mailto:mos99@fastmail.fm]=20
Sent: Friday, May 15, 2009 6:09 PM
To: mysql@lists.mysql.com
Subject: How to capture MySQL queries sent to server?

I'm running Windows XP and I'd like to capture the SQL commands that are=20
sent to the MySQL server. Is there a way to do this on Windows?

TIA
Mike


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dredwards@logicworks=
..net


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg