Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: m
Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: m
Thank u Janqita, I can get
Regards ,
Kranthi
-Original Message-
From: Jangita [mailto:jang...@jangita.com]
Sent: Thursday, August 26, 2010 3:33 PM
To: mysql@lists.mysql.com
Subject: Re: Recover Records
On 26/08/2010 11:35 a, Kranthi wrote:
> Hi all,
>
> My data
On 26/08/2010 11:35 a, Kranthi wrote:
Hi all,
My database size is 1gb.I take backup at 12 am and unfortunately
I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8
records are not there, I think that 8 records inserted between 12 am to 2
am. I am maintaining lo
Hi all,
My database size is 1gb.I take backup at 12 am and unfortunately
I deleted 8 records at 2 am . I checked 8 records in 12 am backup , that 8
records are not there, I think that 8 records inserted between 12 am to 2
am. I am maintaining log file how can I recover particular recor