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

Question

I am running a WordPress website. Today I saw that wp_posts table is crashed. When I tried to repair the table, I am getting the below error:

REPAIR TABLE wp_posts;

error Can't create new tempfile: './[databasename]/wp_posts.TMD' 

repair  status    Operation failed

I have tried to run the below command in the shell:

myisamchk -r -f wp_posts.MYI

error: File 'wp_posts.MYI' doesn't exist

Can anyone help me fix this issue?

Answer 1

Turned out that "myisamchk -r -f wp_posts.MYI" was the right solution. I simply had to go to the data folder.

In my CentOS system, I modified the directory to /var/lib/mysql/[database]/ and found wp_posts.MYI

After removing this file, the repair was successful.

You can kick-start your career in SQL programming by joining our SQL Training course now!