faqts : Computers : Databases : MySQL : Common Problems

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

36 of 84 people (43%) answered Yes
Recently 6 of 10 people (60%) answered Yes

Entry

Is it possible to recover some row after a DELETE, or is it gone and lost for ever?
Does mysql have an undelete capability?

Feb 25th, 2000 15:46
Nathan Wallace, Sasha Pachev


The only way this would be possible is if now new rows were inserted
overwriting the old data, you had not run optimize table or mysisamchk
since delete, and if you used a binary editor to edit the data and index
files -- but you would *really* have to know what you are doing.