List:General Discussion« Previous MessageNext Message »
From:jitendra ranjan Date:August 26 2010 3:35pm
Subject:RE: Recover Records
View as plain text  
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

--- On Thu, 26/8/10, Kranthi <kranthi_pentyala@stripped> wrote:

From: Kranthi <kranthi_pentyala@stripped>
Subject: RE: Recover Records
To: "'Jangita'" <jangita@stripped>
Cc: mysql@stripped
Date: Thursday, 26 August, 2010, 4:20 PM

Thank u Janqita, I can get 

Regards ,

-----Original Message-----
From: Jangita [mailto:jangita@stripped] 
Sent: Thursday, August 26, 2010 3:33 PM
To: mysql@stripped
Subject: Re: Recover Records

On 26/08/2010 11:35 a, Kranthi wrote:
> Hi all,
>             My database size is 1gb.I take
> backup at 12 am and
> 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 records????.

Is it a binary log? if so use mysqlbinlog to search for the insert 
statements and re-insert them.

Jangita | +256 76 91 8383 | Y! & MSN: jangita@stripped
Skype: jangita | GTalk: jangita.nyagudi@stripped

MySQL General Mailing List
For list archives:
To unsubscribe:


MySQL General Mailing List
For list archives:
To unsubscribe:

RE: Recover RecordsKranthi26 Aug
  • Re: Recover RecordsJangita26 Aug
    • RE: Recover RecordsKranthi26 Aug
      • RE: Recover Recordsjitendra ranjan26 Aug
      • RE: Recover Recordsjitendra ranjan26 Aug