From: jitendra ranjan
Date: August 26 2010 3:35pm
Subject: RE: Recover Records
List-Archive: http://lists.mysql.com/mysql/222703
Message-Id: <180991.37342.qm@web95316.mail.in2.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-412183913-1282836943=:37342"

--0-412183913-1282836943=:37342
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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.
=A0
Jeetendra Ranjan
MySQL DBA

--- 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=20


Regards ,
Kranthi



-----Original Message-----
From: Jangita [mailto:jangita@stripped]=20
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,
>
>=A0 =A0 =A0 =A0 =A0 =A0=A0=A0My database size is 1gb.I take backup at 12 a=
m 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=A0 maintaining log file how can I recover particular records????=
.
>

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

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

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dkranthi_pentyala@stripped



--=20


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?unsub=3Djitendra_ranjan=
@yahoo.com

=0A=0A
--0-412183913-1282836943=:37342--