On Wed, Jan 23, 2002 at 10:16:28AM -0500, Keith C. Ivey wrote: > On 22 Jan 2002, at 17:02, Jeremy Zawodny wrote: > > On Tue, Jan 22, 2002 at 09:55:14AM -0500, Keith C. Ivey wrote: > > > > > > As far as I can tell from the documentation, the --log option is > > > supposed to turn on logging to the general query file (section > > > 4.9.2), which shows all connections and queries. > > > > > > I've added that option to the [mysqld] section in my.cnf, and MySQL > > > is seeing the option, because it creates a log file with the name I > > > supplied. But the file is only 162 bytes long and contains only > > > startup information -- nothing about queries, even though there have > > > been thousands of queries since logging was enabled. > > > > > > What am I missing? > > > > Can you show us the my.cnf snipit you're using and tell us which MySQL > > version as well? > > In my.cnf I have this: > > [mysqld] > log=/data/mysql/mysql.log > datadir=/data/mysql > > etc. > > I'm using MySQL 3.23.44 on Red Hat Linux 7.1.
I think that what you want is really: http://www.mysql.com/doc/U/p/Update_log.html Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 20 days, processed 482,793,820 queries (266/sec. avg) --------------------------------------------------------------------- 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
