Hello.
You may use --extend-check option with myisamchk, but usually it finds a lot of garbage, and should be used as a last resort. Francisco Lopez <[EMAIL PROTECTED]> wrote: > Hello all, > I am getting quite desperate on this, since I've been trying to recover > my diary of a whole year of travelling which was stored in a MyISAM > table for a couples of weeks now! The MySQL server was running in a XP > machine and suddenly the hard disk crashed starting my particular > nightmare. I had to use recovery tools to scan the disk and I thought I > was saved when I found the *.frm, *.MYI and *.MYD files and was able to > recover them, but when I tried get the tables back into MySQL and > backup their contents, I found a series of errors that have kept me > down ever since! > The first complain I got when I selected the table was: > > Didn't find any fields in table 'news' > > I then checked the table for errors, and got: > > mysql> check table news; > +----------+-------+-------- -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]