RE: Irritating Discovery

2002-06-13 Thread Luc Foisy
try tail -n 10 /mysql/why.log /tmp/why.log echo /mysql/why.log -Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 6:01 PM To: Paul DuBois Cc: MySQL Subject: Re: Irritating Discovery Paul DuBois wrote: At 13:12 -0700 6/12/02

Irritating Discovery

2002-06-13 Thread Kent Hoover
This works for me: mv /mysql/log /mysql/Oldlog mysqladmin flush-logs MySQL follows the oldlog, keeps writing to it until the flush, when it closes its Oldlog, and open/create-s its logfile. Cheers, Kent - Before

Irritating Discovery

2002-06-12 Thread Van
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 10 /mysql/why.log /tmp/why.log sudo mv /tmp/why.log /mysql/ mysqladmin -u root flush-logs Unfortunately, this set the permissions of

Re: Irritating Discovery

2002-06-12 Thread Paul DuBois
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 10 /mysql/why.log /tmp/why.log sudo mv /tmp/why.log /mysql/ mysqladmin -u root flush-logs

Re: Irritating Discovery

2002-06-12 Thread Van
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 10 /mysql/why.log /tmp/why.log sudo mv /tmp/why.log /mysql/ mysqladmin