MySQL recovery...

[Wizard]

Yes, we tried all of the *isamchk utilities. I'll take a look at what
you have below and try it out. I'll let you know.
Thanks,
Grant M.


> 
> did you try 'myisamchk' (not isamchk as you indicate below)?
> 
> next thing to try:
> - move the MYD file to a safe palce,
> - create the table 
> - copy the MYD file back
> - run myisamchk
> 
>    this will create a new .frm and empty .MYI file, which will help if
> they got currupted.
> 
> 
> 
> 
> On Thu, 2003-10-09 at 08:53, Wizard wrote:
> > Ok, this is something that I've never encountered (or heard of), so I'm
> > looking for unique solutions. This is it:
> > We had a MySQL database [3.23.44] running with approximately 13 gigs of
> > data. For no apparent reason, all of the datafiles lost their MYI files.
> > We have tried several times to recreate the MYI files using the RESTORE
> > and several of the isamchk commands, but this has not been successful
> > (12 of 612 were successful). As mysql is not able to use the datafiles
> > as is, we are looking for any other way in which we can recover this
data. 
> > 
> > One thought was if we could find a datafile conversion program that
> > would convert the MYD files directly to some other database format or
> > XML or anything, we could then reverse the process to get them back. I
> > haven't been able to find anything of this sort, however.
> > ANY suggestions would be helpful,
> > Grant M.
> > 
> > _______________________________________________
> > Discuss mailing list
> > Discuss at blu.org
> > http://www.blu.org/mailman/listinfo/discuss
> -- 
> --------------------------------------------------------------
> Johannes Ullrich                     jullrich at euclidian.com
> pgp key: http://johannes.homepc.org/PGPKEYS
> --------------------------------------------------------------
>    "We regret to inform you that we do not enable any of the 
>     security functions within the routers that we install."
>          support at covad.net
> --------------------------------------------------------------
> 
> 
> _______________________________________________
> Discuss mailing list
> Discuss at blu.org
> http://www.blu.org/mailman/listinfo/discuss
> 
>