Re: Corrupt MYD table - can not repair - Get the free tool..

[Amanullah]

Hi ,

Kindly get the tool (Navicat  version 5.1.1 - trial version) in
http://www.mysqlstudio.com. - I'm Using now..
-Aman.

Mike Brickman wrote:

Where can I get navicat-pro?  I have downloaded a copy of navicat from
the www.navicat.com but this is a gui and does not seem to have the
functionality you describe.  Am I missing something.
Mike Brickman
Radical Solutions
-----Original Message-----
From: Amanullah [mailto:[EMAIL PROTECTED] 
Sent: Wednesday 07 January 2004 02:53
To: miguel solorzano
Cc: Mike Brickman; [EMAIL PROTECTED]
Subject: Re: Corrupt MYD table - can not repair

You can use navicat-pro tool (free ware) to repair
the corrupted MYD files, I was repaired with the same
TOOL.
-Aman.

miguel solorzano wrote:

 

At 19:04 6/1/2004 +0000, Mike Brickman wrote:

If you are able for to build myisamchk from the 4.1 bk tree
it will permit you to set a max row length for to skip them
and continue the recovery.
   

Hi,

I have a client who has managed to corrupt an MYD table so that it
     

can
 

not be repaired.  I have tried:

 Myisamchk -re {table}

And this crashes out with:

 myisamchk: error: Not enough memory for blob at 3960 (need
     

1090519040)
 

and then quits.

There is no complete backup of this file so I would like to recover
     

as
 

much data as possible.

1)       Are there any tools which will allow me to salvage some
     

data?
 

2)       Why does myisamchk not fix the problem?
3)       Are the internal structures of MYD files documented anywhere
(url please)?
4)       What exactly does the error mean?
Any help or clues will be appreciated.

Mike Brickman
Radical Solutions
     

-----------------------------------------------------------------------
   

-
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.556 / Virus Database: 348 - Release Date: 26/12/2003