Ah! Thanks - I see. 5.1.39
Actually I did look i the manual, but failed to note the differences between
5.1.29 and 5.1.29
I was using the syntax for 5.1.29.
Now I am using the correct syntax in /etc/my.cnf
$ grep general /etc/my.cnf
general_log=1
general_log_file=/var/log/mysql/mysql.log
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
Sorry can't remember what version you said you were using; if you have a
version prior to 5.1.29 to log all queries enter the following in the
[mysqld] section of your my.cnf
log = /path/to/logfile/filename.log
Remembering that the path you specify must be writeable by the server.
If you are