Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Logging - Help Turn it on?!

Status
Not open for further replies.

jmilane

IS-IT--Management
Aug 8, 2006
2
US
I am running mysql on windows as part of the xampp stack.

my my.ini reads:

#set-variable=key_buffer=16M
log=hostname.log

so that looks good...

but in WinMySQLAdmin - the LOG = OFF

And it is not logging!

And I need it to.

Help?

How can I turn it on? How can I change this to say LOG = YES?

I am unable to move forward until I get this on. I am new to MYSQL, but have several years of MSSQL, so I am not totally clueless... I dont think...

Thanks a lot for your time.

 
What do you need it to log, slow queries or just everything?

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.
 
Everything. Mostly, queries.

Thanks for the response.

I seem to have figured it out. I installed XAMPP as admin on my machine but use it as jmilane. Whenever I changed my.ini, it was being overwritten.

That sound right?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top