MySQL Forums
Forum List  »  MyISAM

Re: Undelete Rows
Posted by: Ingo Strüwing
Date: February 01, 2007 04:21AM

Hi.

No. This is not possible. When a record is deleted, the start of each of its parts ("blocks") is overwritten with linkage information. All deleted parts of all records make a link or chain.

Hence the records cannot be restored in full.

In theory one could write a utility that follows the delete link. It could extract all non-overwritten parts of the records. They will even be in correct order. But it would be impossible to automatically determine where each record ends. That information was located at the start of the first part of a record, where it is now overwritten. Also it would be difficult to guess where each column starts when the start of the record is missing.

Regards
Ingo

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
32200
January 22, 2007 07:36AM
12649
January 24, 2007 04:38AM
Re: Undelete Rows
15249
February 01, 2007 04:21AM
10826
February 09, 2007 03:39PM
10498
August 25, 2007 05:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.