RE: setting a variable

2004-01-16 Thread Ugo Bellavance 


 -Message d'origine-
 De : Mikael Fridh [mailto:[EMAIL PROTECTED]
 Envoyé : Friday, January 16, 2004 4:19 AM
 À : Ugo Bellavance
 Objet : Re: setting a variable
 
 
 On Thursday 15 January 2004 19.51, Ugo Bellavance wrote:
 
  No problem, I thought I could change any variable at 
 runtime, since 4.0.
 
  I've got no prob with doing it at a restart of the server.  
 I tried putting
 
  set-variable = log=on
 
  at the end of /etc/my.cnf (redhat) and nothing changed.
 
  Thanks,
 
  Ugo
 
 I think it's not a normal variable, it needs to be passed as 
 a command-line 
 parameter to mysqld.
 in my.cnf put:
 
 log
 
 or if you need the logfile in some other dir than the datadir:
 
 log=/var/log/logfile
 
 Mikael.

Thanks, I ried the latter, but I didn't have the right permissions on the file, so I 
tried with just log, it worked.  I then changed my permissions and all went fine.

I have another question: why so many people replied to me off-list, without even 
cc:'ing the list?

Thanks,
 

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

RE: setting a variable

2004-01-15 Thread Ugo Bellavance 


 -Message d'origine-
 De : Tobias Asplund [mailto:[EMAIL PROTECTED]
 Envoyé : Wednesday, January 14, 2004 1:53 PM
 À : Ugo Bellavance
 Cc : [EMAIL PROTECTED]
 Objet : Re: setting a variable
 
 
 On Wed, 14 Jan 2004, Ugo Bellavance wrote:
 
  mysql 4.0.17 on redhat 9 or debian 3.0
 
  mysql show variables like 'log';
  +---+---+
  | Variable_name | Value |
  +---+---+
  | log   | ON|
  +---+---+
  1 row in set (0.00 sec)
 
  mysql set global log=on;
  ERROR 1193: Unknown system variable 'log'
 
  What am I doing wrong?
 
 Currently you cannot start logging while the server is running.
 

No problem, I thought I could change any variable at runtime, since 4.0.

I've got no prob with doing it at a restart of the server.  I tried putting

set-variable = log=on

at the end of /etc/my.cnf (redhat) and nothing changed.

Thanks,

Ugo

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

RE: setting a variable

2004-01-14 Thread Ugo Bellavance 
Sorry, 4.0.16, not 4.0.17, if it changes anything.

 -Message d'origine-
 De : Ugo Bellavance 
 Envoyé : Wednesday, January 14, 2004 12:07 PM
 À : [EMAIL PROTECTED]
 Objet : setting a variable
 
 
 mysql 4.0.17 on redhat 9 or debian 3.0
 
 mysql show variables like 'log';
 +---+---+
 | Variable_name | Value |
 +---+---+
 | log   | ON|
 +---+---+
 1 row in set (0.00 sec)
 
 mysql set global log=on;
 ERROR 1193: Unknown system variable 'log'
 
 What am I doing wrong?
 
 Thanks,
 
 Ugo
 
 -- 
 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]

Re: setting a variable

2004-01-14 Thread Tobias Asplund 
On Wed, 14 Jan 2004, Ugo Bellavance wrote:

 mysql 4.0.17 on redhat 9 or debian 3.0

 mysql show variables like 'log';
 +---+---+
 | Variable_name | Value |
 +---+---+
 | log   | ON|
 +---+---+
 1 row in set (0.00 sec)

 mysql set global log=on;
 ERROR 1193: Unknown system variable 'log'

 What am I doing wrong?

Currently you cannot start logging while the server is running.

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