Graeme B. Davis writes:
> Is there a way I can recover a table that still has all of the data in it,
> but the records are deleted? myisamchk says this:
>
> Checking MyISAM file: mails.MYI
> Data records: 0 Deleted blocks: 153
> - check file-size
> - check key delete-chain
> - check record delete-chain
> - check index reference
> - check data record references index: 1
> - check record links
>
> I'm hoping I can get those 153 back :(
>
> Any suggestions
>
Hi!
You can do it by studying carefully MyISAM table format and by using
some binary / hex editor.
There is more elegant way, which is to use a backup.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
