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]
