| 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 Puente | 13 Nov |
| • Re: log sql queries? | John Daisley | 13 Nov |
| • Re: log sql queries? | Sydney Puente | 15 Nov |
