Mac OS X 10.4.6 (Tiger), MySQL 5.0.21.
Hi folks. I'm needing to start up my general query log to see what's
ticking me off.
I've looked into safe_mysqld but it's confusing as ... something
that's confusing.
Anybody know how I can easily turn this thing on for a day, then turn
it off?
put
log
or
log=/path/to/file
in your config file (my.cnf) and restart the server. To turn it off
you have to take it out of the my.cnf and restart the server.
I've put in a request to make the general log something that can be
dynamically turned on.
-Sheeri
On 5/19/06, Rich [EMAIL
Yes. idea #1 -- reply all, including the list.
idea #2 -- what's in the error logs?
Check that the user that runs mysql has permission to write to the
file and that /var/log exists.
-Sheeri
On 5/19/06, Rich [EMAIL PROTECTED] wrote:
Hi there.
I added the my.cnf file (it wasn't there) and
Why this list goes private I'll never know. I guess that's why I
always get two copies.
In the errors log:
Found option without preceding group in config file: /etc/my.cnf at
line: 1
Fatal error in defaults handling. Program aborted
/var/log/ does indeed exist
root runs mysqld
On
That means that your options have no group. Options should go under
the program they're intended to be run under, for instance
[mysqldump]
user=root
[mysql.client]
user=guest
[mysqld]
log=/path/to/logfile
You want the mysqld program (mysql server) to use the general log, so
put it under a