Thank u Janqita, I can get 

Regards ,
Kranthi



-----Original Message-----
From: Jangita [mailto:[email protected]] 
Sent: Thursday, August 26, 2010 3:33 PM
To: [email protected]
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: [email protected]
Skype: jangita | GTalk: [email protected]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[email protected]



-- 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[email protected]

Reply via email to