Re: Fwd: Dynamic enabling of log files

[Nils Valentin]

Hi Prem,

Which version are you curently using 3.23.xxx ??

Whats the XXX in your version ???

What do the change log files say at the www.mysql.com homepage ?

Best regards

Nils Valentin
Tokyo/Japan


Prem Soman wrote:
Thanks neils!

  i have gone thru what u referred long before, i know
 that this "set" method is not fully supported in 3.23
version, thats why i posed this question, i wanted to
know whether there is any other way to do it.
when i make changes to my.cnf file i am able to do it
but it is not immediatly reflected since mysqld reads
from the my.cnf file only when it restarts.... i
thought there must be some sort of command line
utility  or ... to enable and disabke log files
without restarting the server.
can u also tell me from what version onwards is this
type of dynamic setting for log files allowed.
Regards,
Prem S 

--- Nils Valentin <[EMAIL PROTECTED]> wrote: > 

Hi Prem,

That question was just here 2 days ago, so easy to
answer. ;-)


Logs can be enabled/disabled for the session with
SET SQL_LOG_OFF | 
SQL_LOG_BIN | SQL_LOG_UPDATE. But these commands are
not supported in 
v3.23.52:
       http://www.mysql.com/doc/en/SET_OPTION.html

Best regards

Nils Valenin
Tokyo/Japan
2003年 8月 13日 水曜日 13:30�Prem Soman
ã?•ã‚“ã?¯æ›¸ã??ã?¾ã?—ã?Ÿ:
Note: forwarded message attached.



________________________________________________________________________

Want to chat instantly with your online friends? 
Get the FREE Yahoo!

Messenger http://uk.messenger.yahoo.com/
--
---
Valentin Nils
Internet Technology
E-Mail: [EMAIL PROTECTED]
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils


________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]