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 <kranthi_penty...@iicindia.com> wrote: From: Kranthi <kranthi_penty...@iicindia.com> Subject: RE: Recover Records To: "'Jangita'" <jang...@jangita.com> Cc: mysql@lists.mysql.com Date: Thursday, 26 August, 2010, 4:20 PM 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 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: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kranthi_penty...@iicindia.com -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jitendra_ran...@yahoo.com