开发者

Viewing earlier Query log - MySQL

开发者 https://www.devze.com 2023-03-01 00:33 出处:网络
I want to se开发者_开发技巧e mysql queries [history, log] [select,insert,update,...] [which i executed] !

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"
0

精彩评论

暂无评论...
验证码 换一张
取 消