Mysql table repair failed: "Can't create new tempfile"

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

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

After removing this file, repair was successful.

Try stopping your service using the following command sudo service mysql stop

Now do the repair check myisamchk -r -f -o /var/lib/mysql/DatabaseName/wp_posts

Start your service and enjoy it!

It works for me