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 on version 5.1.29 or later use
general_log=1
general_log_file=/path/to/logfile/filename.log
If you have a very busy server the general query log will get very very
big very quickly. Its best to only enable the general query log for
identifying problems and performance tuning.
Take a look at the manual(http://dev.mysql.com/doc/refman/5.1/en/)! You
can get answers to questions like this so much quicker from there.
Regards
John Daisley
On Fri, 2009-11-13 at 16:43 +0000, Sydney Puente wrote:
> 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
>
>
>
>
