MYSQL Error Message - Can't open file: '

[Anon]

I have a problem with a data file that was open when the operating system was inadvertantly shutdown.

I get this error mesage when I try to access the table via phpmyadmin:

Error
SQL-query :

SELECT * FROM folio2 LIMIT 0, 30

MySQL said:

Can't open file: 'folio2.MYD'. (errno: 145)

When I select the database in phpmyadmin the table is shown with an "In use" comment alongside.

I have tried a flush - Nothing happened.

I have also tried isamchk and myisamchk all to no avail. Whilst myisamchk did open the table it corrupted the data in the process, changing my incrementing ids into 6 figure numbers and didnt pick up all the breaks in fields etc.

It appears to me that there is a flag set somewhere in the file that provides the indication it is still in use. Perhaps if I can locate this I can rectify my problem. Generally the data all seems OK.

Can I manually edit this out? Is there any suggestions to fix this file?

It is too large to rekey (unless I absolutely have to!).

All suggestions gratefully accepted

Hebbs

[trooper]

Hebbs You have a corrupt table.

Connect to the db via the command line and then run "repair table folio2"
This will then attempt to repair the table for you.

[Anon]

No, that didnt work.

Tried the REPAIR TABLE alone and then with both QUICK and EXTENDED.

The EXTENDED repair got me closer to the right amount of lines (Still a few short of whats real) but both increased any numeric values in the table by a figure of 2105345.

Any thoughts?

Hebbs