List:General Discussion« Previous MessageNext Message »
From:Sydney Puente Date:November 13 2009 4:43pm
Subject:log sql queries?
View as plain text  
OK thanks to some help from this list I now have a blank my.cnf file in /etc
And I want to set up logging of all sql  queries.

So I have tried:

SET GLOBAL general_log = 'ON';

and/or putting  (only)  /var/log/mysql/mysql.log
in my.cnf and doing a restart via /etc/init.d
(have a pid file now -Ta!)

but still no sql commands in the log file.

There are stop/start up commands in /var/log/mysqld.log

but that is about it

Any suggestions?

Syd


      
Thread
log sql queries?Sydney Puente13 Nov
  • Re: log sql queries?John Daisley13 Nov
Re: log sql queries?Sydney Puente15 Nov