RE: Recover Records
am 26.08.2010 11:35:48 von kranthi
------=_NextPart_000_0001_01CB4530.2B5D4270
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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 records????.
Thanks & Regards,
Kranthi
------=_NextPart_000_0001_01CB4530.2B5D4270--
Re: Recover Records
am 26.08.2010 12:02:42 von Jangita
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 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@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
RE: Recover Records
am 26.08.2010 12:50:05 von kranthi
Thank u Janqita, I can get
Regards ,
Kranthi
-----Original Message-----
From: Jangita [mailto:jangita@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 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 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@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=kranthi_pentyala@iicindia .com
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
RE: Recover Records
am 26.08.2010 17:35:43 von jitendra ranjan
--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 wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
Date: Thursday, 26 August, 2010, 4:20 PM
Thank u Janqita, I can get=20
Regards ,
Kranthi
-----Original Message-----
From: Jangita [mailto:jangita@jangita.com]=20
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,
>
>=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@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dkranthi_pentyala@iicind ia.com
--=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
--0-412183913-1282836943=:37342--
RE: Recover Records
am 26.08.2010 17:39:50 von jitendra ranjan
--0-1372109513-1282837190=:75255
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 wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
Date: Thursday, 26 August, 2010, 4:20 PM
Thank u Janqita, I can get=20
Regards ,
Kranthi
-----Original Message-----
From: Jangita [mailto:jangita@jangita.com]=20
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,
>
>=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@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com
--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=3Dkranthi_pentyala@iicind ia.com
--=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
--0-1372109513-1282837190=:75255--