MySQL Forums :: MyISAM :: Undelete Rows

Advanced Search

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


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.


Ingo Strüwing, Senior Software Developer - Storage Engines

Options: ReplyQuote

Subject Views Written By Posted
Undelete Rows 25502 Brian Connell 01/22/2007 07:36AM
Re: Undelete Rows 10717 Brian Connell 01/24/2007 04:38AM
Re: Undelete Rows 12255 Ingo Strüwing 02/01/2007 04:21AM
Re: Undelete Rows 9772 Shane Bester 02/09/2007 03:39PM
Re: Undelete Rows 9206 Shane Bester 08/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.