Paul DuBois wrote: > > At 13:12 -0700 6/12/02, Van wrote: > >Greetings: > > > >Perhaps a bug, even. After about 5 months my mysql log file grew to over > >300MBytes and I figured I'd do something about it as follows: > >tail -n 100000 /mysql/why.log > /tmp/why.log && sudo mv /tmp/why.log > >/mysql/ && > >mysqladmin -u root flush-logs > > > >Unfortunately, this set the permissions of why.log as a user other than mysql, > > So what happened? Did this command: > > sudo mv /tmp/why.log /mysql/ > > replace your old /mysql/why.log file with one owned by root?
Yes. Well, actually owned by user vanboers (I use sudo, not root). > > If so, I guess I wouldn't be surprised. > > >preventing mysqld from logging queries (exactly what I'd hoped to > >avoid), so I: > >sudo chown mysql.mysql /mysql/why.log But, this should have fixed it so mysqld could start writing to it again... > >- and - > >mysqladmin refresh > > And, this should have written to it... This: mysqladmin shutdown && /etc/rc.d/rc.mysql shouldn't have been necessary. See what I mean? Van -- ================================================================= Linux rocks!!! http://www.dedserius.com/ ================================================================= --------------------------------------------------------------------- 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