INDEX

[Marcel David]

Hi,

I´m in Brazil and I have an old system written in PHP using MySQL 3.23.
My application always works very well (4 years without great problems), but last week I had a HardDisk problem in my Server and my backup was not suficient to recover all data.
I got MySQL files (.FRM, .MYD, .MYI) from HD and installed it on another server.
When I try to list all data from a table (select), my result is blank. But if I select part of this table data (select where a few hours before the HD crash), it shows perfectelly my records.
I try to select some records among that crashes data and I have success in some cases and not in others.

I think it's an index problem... I tried to recover using myisamchk -r (-o, -k 0, -f, -q), REPAIR TABLE, ALTER TABLE ENABLE KEYS... but I didn't have success...

I think my .MYD file is ok, but my .MYI is crashed.
Is there any program that resolve my problem? Someone can help me, please?

Thanks!!!
(Sorry, my English is poor)