Hello.
> Absolutely nothing happens.... It works for me in 4.1.13. See: [EMAIL PROTECTED] mysql-debug-4.1.13-pc-linux-gnu-i686]$ ls -l ../logs/log_r total 12 -rw-rw---- 1 gleb gleb 1095 Aug 12 00:04 log_r.000002 -rw-rw---- 1 gleb gleb 79 Aug 17 17:19 log_r.000003 -rw-rw---- 1 gleb gleb 84 Aug 17 17:19 log_r.index [EMAIL PROTECTED] mysql-debug-4.1.13-pc-linux-gnu-i686]$ lmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.13-debug-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 1 DAY); Query OK, 0 rows affected (0.01 sec) mysql> quit Bye [EMAIL PROTECTED] mysql-debug-4.1.13-pc-linux-gnu-i686]$ ls -l ../logs/log_r total 8 -rw-rw---- 1 gleb gleb 79 Aug 17 17:19 log_r.000003 -rw-rw---- 1 gleb gleb 42 Aug 17 17:19 log_r.index File log_r.000002 was deleted after the 'PURGE...' statement. "Chris Knipe" <[EMAIL PROTECTED]> wrote: > 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. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
