Account crash

[dripone 0]

Hey guys!

I tried to repair my account table, but it keeps saying that it's marked as crashed.

 

Can't create new tempfile: './account/account.TMD'

Last time I used a query to fix the item table, but I lost that query somewhere.
Can someone tell me what to do now?

[Ayaka 322]

What did you do? 
You should run myisamchk on the .MYD file.

https://dev.mysql.com/doc/refman/5.0/en/myisamchk.html

If this is not working you can removing old tempfiles like this (dont know the path on FreeBSD but just check where to find mysql - this is an Debian Linux example):

rm /var/lib/mysql/*/*.TMD

Im sure that this is a permission problem in group. You are trying this with navicat, or?

Edited October 21, 2015 by Ayaka