Corrupted Database! HELP!

[tdsii]

Hello,

I run my site on VPS and recently it got corrupted, due to limitation in VPS disk size, it goes 100% full when i try to repair.

How i can bypass this issue?

Is it possible to copy the actual mysql files (MYI,MYD,frm) to another server and fix the problem using myisamchk ?

I got the below problem when i tried fixing it after moving those 3 files for that table into another server:

[****@csm wguru]$ myisamchk -r post.MYI
myisamchk: error: 'post.MYI' doesn't have a correct index definition. You need to recreate it before you can do a repair

but it works on the actual server, but as explained above due to VPS limitations i can not fix it locally...

please advise

 

[Lock Down]

It should work and definitely won't hurt to try it. Just be sure to check the size of the file after fixed. And keep backups of those files. Be sure to stop mysql before doing it.

 

[tdsii]

is it possible to use --tmpdir= as an external server since i dont have much space?
anyone have experience in this?