I want to purge bin logs which are older than 4 days. I want to keep 4 days
of bin logs so that in the event of any data issue, i can restore it from
bin logs. So, i tired to use
PURGE MASTER LOGS BEFORE '2008-05-07 00:00:00';
But it did not work. Can you please help me on this
On 5/17/08, Juan Eduardo Moreno <juaneduardomc@stripped> wrote:
> Use, PURGE MASTER LOGS TO 'name of the last binary that you want leave in
> your disk';
> On Sat, May 17, 2008 at 8:56 AM, Ananda Kumar <anandkl@stripped> wrote:
>> Hi All,
>> I using this command to purge binary logs on master, but i dont see the
>> binary logs getting deleted. These binary logs are listed in index file.
>> I am using mysql version 5.0.41 community version. Can you please let me
>> know if any thing else need to be done for this to work.
>> log-bin is enables.
>> PURGE LOGS BEFORE '2008-05-07 00:00:00';