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=arch...@jab.org
