I'm using mysql that was distributed by mysql.com.  I seem to be having
a problem with logrotate.  When I run logrotate manually on mysql only,
the logs seem to rotate fine.  But, when it runs in the cron job, it
creates the new log, but mysql continues to log to the old log.  
My mysql logrotate entry looks like:

/var/log/mysqld.log {
        create 644 mysql mysql
        notifempty
        daily
        rotate 2
        missingok
        nocompress
    postrotate
        # just if mysqld is really running
        if test -n "`ps acx|grep mysqld`"; then
                /usr/bin/mysqladmin flush-logs
        fi
    endscript
}

I have also tried using "mysqladmin refresh".  Any ideas why the logs aren't 
being rotated properly under cron?
-- 
Jiann-Ming Su  [EMAIL PROTECTED]  404-712-2603
Development Team Systems Administrator
General Libraries Systems Division



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list


---------------------------------------------------------------------
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

Reply via email to