Viewing earlier Query log - MySQL
I want to se开发者_开发技巧e mysql queries [history, log] [select,insert,update,...] [which i executed] !
Can anyone help me on this ?I'm using MySQL Version : 5.5.8 [which i got from WAMP]
I tried changing settings from console, and failed ! [change gets lost after restart] i've asked it before, but no working answer !Sourav's answer no longer works. As of July 2013, you need:
general-log=1
general-log-file = "C:\wamp\logs\mysql_general.log"
Change the following settings in my.ini
:
[mysqld]
port=3306
long_query_time = 1
slow_query_log = 1
slow_query_log_file = "E:/wamp/logs/slowquery.log"
log = "E:/wamp/logs/genquery.log"
精彩评论