Viewing earlier Query log - MySQL

Question

I want to see 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 !

http://stackoverflow.com/questions/5755696/saving-mysql-settings — Sourav, Apr 28 '11 at 03:43

score 7 · Answer 1 · edited May 23 '17 at 12:22

7

Sourav's answer no longer works. As of July 2013, you need:

general-log=1
general-log-file = "C:\wamp\logs\mysql_general.log"

edited May 23 '17 at 12:22

Community

1
1

answered Jul 27 '13 at 04:25

Jonathan

6,038
7
44
66

score 4 · Accepted Answer · edited Jul 27 '13 at 11:43

4

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"

edited Jul 27 '13 at 11:43

Cody Gray

230,875
49
477
553

answered Apr 28 '11 at 03:49

Sourav

16,318
34
98
153

Viewing earlier Query log - MySQL

2 Answers2

Linked