Cant repair database - Mysql table repair failed: “Can't create new tempfile”

Question

When trying to repair a crashed database I get this error

Mysql table repair failed: “Can't create new tempfile”

How can I fix it?

Answer 1

In CentOS login as root and do

myisamchk -r -f table_name.MYI

Tis will fix the problem. Remember to change table_name for the table in question.

You can change directory to /var/lib/mysql/[database]/

to see the mysql files on Centos.

 

Comments

remove .MYI if it fails with it