Is myisamchk hanging?

[AlternativeWeb]

Data records: 2400361
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
2400000

myisamchk -r --force --fast /var/lib/mysql/forum/posts.*

Is it normal to be stuck at "Fixing index 8" for an hour?

---------- Post added at 04:12 AM ---------- Previous post was at 03:29 AM ----------

It's now completed, but gives me an error:

myisamchk: error: File '/var/lib/mysql/forum/posts.TMD' doesn't exist

Is there a way to correct this?

AlternativeWeb Reviewed by AlternativeWeb on 7th Apr 2012. Is myisamchk hanging? myisamchk -r --force --fast /var/lib/mysql/forum/posts.* Is it normal to be stuck at "Fixing index 8" for an hour? ---------- Post added at 04:12 AM ---------- Previous post was at 03:29 AM ---------- It's now completed, but gives me an error: myisamchk: error: File '/var/lib/mysql/forum/posts.TMD' doesn't exist Rating: 5

[JamesVaporH]

Do the repair via phpmyadmin or do

myisamchk -r /var/lib/mysql/forum/*.MYI
or
myisamchk -r /var/lib/mysql/forum/posts.MYI

[AlternativeWeb]

Repair in phpMyAdmin timed out. The table is too big for it.

I tired:
myisamchk -r /var/lib/mysql/forum/*.MYI

and it completed without any errors, but when I tried to do:
myisamchk -r --force --fast /var/lib/mysql/forum/posts.*

I got back the same message as the first time:
myisamchk: error: File '/var/lib/mysql/forum/posts.TMD' doesn't exist

Do you know if there anything else I can try?

[Lock Down]

Is your tmp directory full or too small? That is where the tmd is usually stored.

you can try using this command :

 myisamchk -r -f  --tmpdir=/home, -t /home  /var/lib/mysql/forum/posts.MYI

[AlternativeWeb]

In regards to my reply above, when I said there wasn't an error.. . I was wrong. There was an error, but it scrolled up and didn't see it the first time. It was the same error message I had from the start though.

@Lock Down: I didn't even know I was able to even set a limit to it. How would I be able to check?

[Gavo]

This site is using a hacked database of W junction