Faqts

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

Entry

What SQL statement did the user execute? When did they execute it?

May 12th, 2008 21:20
i can do it, Mike Chirico,


If you have binary logging turned on, it's possible to see all the
statements executed.  
mysql> show binlog events;                                             
Or from the Unix/Linux shell:
$ mysqlbinlog <logfile>
$ mysqlbinlog /usr/local/var/mysqlLOGbin.000001
For tips on how to setup binary logging reference the following (TIP 25,
TIP 24, and TIP 30)
http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
The above link also shows a better formatted example.
Hope this helps.
http://www.stupidarticles.com
http://www.halazona.com
http://www.shikapika.com
http://www.stakoza.com
http://www.uploadarticles.com
http://www.ganazat.com
http://www.damima.com
http://www.tarabiza.com
http://www.articlesxarticles.com
http://www.articlesfreedirectory.com