we do the same thing.  works just fine.

On Wed, Oct 8, 2008 at 10:55 AM, Tom Brown <[EMAIL PROTECTED]> wrote:

>
>  According to the doc for this parameter, "Possible removals happen at
>> startup and at binary log rotation."  This implies that removal is not
>> automatic - you have to either flush logs or bounce the server.  We use
>> "Purge Master" periodically.
>>
>>
>
> i do this from cron
>
> mysql -e "PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)"
>
> perhaps not that 'clean' but it does the trick
>
>


-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Reply via email to