New answers tagged recovery
myisamchck did its best job, so that may be the maximum what you can get out of mytable.MYD. The structure of MyISAM record is pretty simple, integers are stored in packed format, strings are prefixed with their length(1 or 2 bytes). So you can write a C program with pre-defined pattern that would try to fetch records of out the MYD file. This approached ...
Many (most?) redo records actually need the block to be in some reasonable state in order to replay into it. Consider: Not all WAL records are row-level. Say you read and replay a WAL record that says "I defragmented this block according to the usual rule of defragmenting blocks". This would be a deterministic operation given the correct starting ...
If you do not have any backups that contains the deleted table, you can't restore the database to it's original form.
Top 50 recent answers are included