On Thu, 5 Apr 2001, Roel Vanhout wrote:
> Hi all,
>
> Is there a way to turn the query logging on and off while the database
> server is running? Right now I have a script that stops and restarts the
> database with loggin on or off depending on the parameters, but this is
> not so great; I was wondering if there is another way. Also, is there a
> way to query the server if logging is on or off? I'd like to write a
> nice gnome applet to start/stop logging but I'm not sure how to get this
> value.
You can get whether the server is loging or not through
$ mysqladmin -p variables
and check the value of, you guessed it, the entry 'log'
I don't know if you can make the server turn logging on/off while it is running. But
you can swithc logging on/off for a particular session giving:
SET SQL_LOG_OFF=1 (the client must have the Process privilege)
regards,
thalis
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php