List:General Discussion« Previous MessageNext Message »
From:sasha Date:April 20 2000 5:57pm
Subject:Re: undeleting table
View as plain text  
"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                  |
+------------------------------------------------------------------+
Thread
Table Design Questionlkeeton20 Apr
  • undeleting tableGraeme B. Davis20 Apr
    • Re: undeleting tablesinisa20 Apr
    • Re: undeleting tableThimble Smith20 Apr
      • UPDATE Using values from another table...August Zajonc24 Apr
      • UPDATE using values from other table.August Zajonc24 Apr
        • Re: UPDATE using values from other table.sinisa24 Apr
  • Re: undeleting tablesasha20 Apr
    • RE: undeleting tableMark D Wolinski20 Apr
      • Re: undeleting tableThimble Smith20 Apr
        • Re: undeleting tableJeremy Cole20 Apr