From: sasha
Date: April 20 2000 5:57pm
Subject: Re: undeleting  table
List-Archive: http://lists.mysql.com/mysql/34768
Message-Id: <38FF44FC.7F6EF76B@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

"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                  |
+------------------------------------------------------------------+