Hi, I found the same thing running v4.1.9. To make it work I first had to issue:
PURGE MASTER LOGS TO 'logfilename' ...only then was I was able to use the 'BEFORE' variant i.e. PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY); The first one must resync some sort of log index file or something which the second one needs to work!? Ian. > > Lo everyone, > > Small issue.. MySQL 4.1.12... > > > PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY); > > Absolutely nothing happens.... > > PURGE MASTER LOGS TO 'blah-bin.00030'; > > Logs are cleared immediately. > > Any reason why LOGS BEFORE is not working??? > > > Thanks, > Chris. -------------------------------------------------------------------------------- IMPORTANT: This email (including any attachments) may contain confidential, private or legally privileged information and may be protected by copyright. You may only use it if you are the person(s) it was intended to be sent to and if you use it in an authorised way. No one is allowed to use, review, alter, transmit, disclose, distribute, print or copy this e-mail without appropriate authority. If this e-mail was not intended for you and was sent to you by mistake, please telephone (07 3842 8888) or e-mail me immediately, destroy any hard copies of this e-mail and delete it and any copies of it from your computer systems. Any legal privilege and confidentiality attached to this e-mail is not waived or destroyed by that mistake. It is your responsibility to ensure that this e-mail does not contain and is not affected by computer viruses, defects or interference by third parties or replication problems (including incompatibility with your computer system). -------------------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]