"Graeme B. Davis" wrote:
>
> 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
Take the table off line, open it in binary editor, and have fun. Each deleted
record, if it had not been reused will start with 00 byte - just change it to a
non-zero value...
Or how about this, let's do Basic Email Support Promotional - send me the table,
and if I can recover it, you purchase basic e-mail support - is that a deal?
--
Sasha Pachev
+------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
