MySQL .... "in use" instead of info about the number of entries/size

#1016 - Can't open file: 'keyword1.MYI'. (errno: 145)

[Bigzed]

Hi,
Ok. I have a Problem.
A biiig Problem.

I had a few Problems with a MySQL table (1,900,000 entries - 114MB). So I klicked the "repair" option using PHPmyAdmin.

Since then this is the Situation:
On the Keyword-Overview, where you normaly get the information about what type the table is, the size and how many records all it says is "in use".
It is like that for at least 10 minutes.

When trying to browse the table this error message comes up:
"#1016 - Can't open file: 'keyword1.MYI'. (errno: 145)"

Whats wrong?
Do I just have to wait longer until the Repair-process is done (is it possible that it takes that long?), or did it get stuck on some point and the 114 MB of Data are lost?

Thanks,
Florian.

[Bigzed]

come on you guys I really need help with this, my table is still in the same state (since 20 hours).

Bigzed.

[jatar_k]

I would suggest doing the repair via the commandline

the browser/script via phpmyadmin is probably timing out, I would suggest shutting down apache while you do this as well to ensure that the repair is the only thing happening and no more connections are made to the db.

If you get the same error from the copmmand line i would also try shutting down mysql and restarting it, then attempting the repair again.

[jatar_k]

also read through this for more info
[dev.mysql.com...]

[Bigzed]

Hi,
thanks for your answer.
The problem is: I don't have an own server/root rights. I just have a simple Webspace Account.
Is the only solution to contact the host and ask them to do it? (their support is not the best..)

Bigzed.

[jatar_k]

you should at very least have commandline access available so you can run the repair that way