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
MySQL AB, www.mysql.com
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.