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
#x27;\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.0
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.
--
MyS
ethod to purge the master logs. I know I can
do it with "PURGE MASTER LOGS TO 'mysql-bin.010';", but I need know the last
log file to automate it.
Somebody know the way.
TIA
Hi,
I'm looking for an automatic method to purge the master logs. I know I can
do it with "PURGE MASTER LOGS TO 'mysql-bin.010';", but I need know the last
log file to automate it.
Somebody know the w
I found the problem ! The command is case sensitive also on WINDOWS . I
wrote the command as upcase and all is ok.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 29, 2002 12:33 PM
Subject: PURGE MASTE
> In my network there are 1 master and 3 slaves all with 3.52 on WIN NT. All
> slaves are linked correctly to the same bin-log file PISSARRO-BIN.047.
>
> With the command SHOW MASTER LOGS I see 3 files
> PISSARRO-BIN.045
> PISSARRO-BIN.046
> PISSARRO-BIN.047
>
> If I use the command
> purge logs
Ralf,
Wednesday, July 03, 2002, 4:48:11 PM, you wrote:
RN> The subject says it all: What rights does a user need to have (minimal
RN> rights of course) to be able to execute PURGE MASTER LOGS command?
Since version 4.0.2 user must have SUPER privilege.
before 4.0.2 you must have P
Hello!
The subject says it all: What rights does a user need to have (minimal
rights of course) to be able to execute PURGE MASTER LOGS command?
Thanks in advance
Ralf
For the poor little filter: sql query
--
Ralf Narozny
SPLENDID Internet GmbH & Co KG
Skandinaviendamm 212, 24109
