corupt DB & reapir isn't working

[Mutt]

My DB went to ++++. Reapir wouldn't work becaue the user tabel and template table were effected. I modified repair so that it doesn't require global.php and it was able to handle fixing those tables. Everything is squared away now except the post table. Normally if you run repair a couple times it will straighten it out, but not this time. I've gotten the identical error evey time I've run it.

Checking table post
Table Operation Type Text
sfn2_com.post check warning Table is marked as crashed and last repair failed
sfn2_com.post check warning Size of indexfile is: 6439936 Should be: 5237760
sfn2_com.post check warning Size of datafile is: 50902104 Should be: 50870472
sfn2_com.post check error Found 131607 keys of 60786
sfn2_com.post check error Corrupt
Repairing table post
sfn2_com.post repair error 122 when fixing table


I know the answer is to resore from a backup, but I don't have a recent one. :( I even modified repair so you can set the table you want it to fix instead of fixing them all so It would just hammer the post table, but the error message and the numbers haven't changed at all.

are there other tools out there? Has anyone made other mods to repair that might help?

I've tried repairing post from phpmyadim, same error. I checked vb.com and found this

"Once mysql is shut down run this command in shell/telnet/ssh: myisamchk -r -u root -p sfn2_com"

and tried it, but myisamchk didn't recognize -u or -p. if I remove those options, it didn't find sfn2_com ?!?!?!? I think this might able to fix it if I could only get it working. If anyone has anysuggestions about running it, please let me know.

I don't want to lose my posts and I don't want the site to be down any longer. I'm desprately looking fro a solution

thanks in advance for any help or suggestions

[Dark_Wizard]

Hey Jeff....first off -u is for username and -p is for password and there shouldn't be a space in there...try it as -uusername and -ppassword. Is this hosted on your webserver or hosted elsewhere?

[Mutt]

it looks like I have to be in the database dir or give the full path. I'm looking it up now and trying again. Thansk for the no space tip. I'll try it

[Dark_Wizard]

Can you go on ICQ?

[Mutt]

don't have icq on my laptop, but thanks. I'm not at home

[Dark_Wizard]

Ok...you still haven't answered as to whether or not this is on a hosted server or not. If you have access to the var directory you will find the mysql directory there..that is the default install location...

[Mutt]

I got it running. I've been tring for over a day. I come here and make a post and 5 min later if figure it out. :)

I had to cd to the dababase dir and run it.

i'm still gettin error 122. I've tried using the -f option.

it's a semi de server hosted elsewhere, but I have full access. yeah, I found it thanks

[Mutt]

Great googly moogly!!! I think it worked finally. it couldn't write the temp file, so I guessed that it was a lack of hard drive space and deleted a ton of photo albums and tried again. it went through! I just ran repair again and everything seems fine. I'm opening back up to see what I lost.

Dark wiazrd, thanks man.

[Dark_Wizard]

Can you do a dump of that table and send it to me? I'll pm you my email addy