Ok, but this only works for the current session, if I close and restart the client the settings are reset...
-----Ursprüngliche Nachricht----- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 11:19 An: [EMAIL PROTECTED] Betreff: Re: switch query logging while the server is running [EMAIL PROTECTED] wrote: >>Description: > It would be nice if general query logging could be switched on and off > while the MySQL server is running, and not only at startup time. > While debugging an application that uses foreign database access > libraries, this would be very helpful. One could switch on logging, > perform an activity, switch off logging, and look what has happened. > Otherwise, the server has to be restarted to change logging, which > is a bit annoying... >>How-To-Repeat: > mysql> show variables like 'log'; > +---------------+-------+ > | Variable_name | Value | > +---------------+-------+ > | log | ON | > +---------------+-------+ > 1 row in set (0.00 sec) > > mysql> set log off; > ERROR 1193: Unknown system variable 'log' > mysql> set session log off; > ERROR 1193: Unknown system variable 'log' > mysql> This variable is called SQL_LOG_OFF. Please, read the manual: http://www.mysql.com/doc/en/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
