First step of successful MySQL data recovery is to find InnoDB pages with your data. Let’s call it first, because prerequisite steps are already done.
InnoDB page type is a two bytes integer stored in the header of a page. For MySQL data recovery two are important:
- FIL_PAGE_INDEX. Pages of this type are nodes of B+ Tree index where InnoDB stores a table.
- FIL_PAGE_TYPE_BLOB. So called external pages, where InnoDB keeps long values of BLOB or TEXT type.
stream_parser …[Read more...]