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

Question

I run a WordPress website. Today I found that wp_posts table is crashed. When I tried to repair the table, I got the following error:

REPAIR TABLE wp_posts;

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

repair  status    Operation failed

I tried to run the following command in shell:

myisamchk -r -f wp_posts.MYI

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

Can you please tell me what else I can try to fix this problem?

score 32 · Accepted Answer · edited Sep 10 '18 at 14:48

32

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.

edited Sep 10 '18 at 14:48

Giacomo1968

25,759
11
71
103

answered Jul 28 '15 at 19:05

James Zhao

671
1
8
17

worked for me too! But, someone knows why this happens? I dont wanna do this again hahahah – Rangel R. Morais Feb 14 '18 at 18:59

score 23 · Answer 2 · answered Feb 10 '17 at 20:14

23

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

answered Feb 10 '17 at 20:14

Gabriel Rodulfo

231
2
2

This is magic. Thank you s much! You saved me. I tried. `sudo myisamchk -r -f -o /var/lib/mysql/[dbname]/wp_options` – Jed May 19 '20 at 10:10

score 1 · Answer 3 · answered Jul 28 '15 at 18:50

1

Try adding the following line to your wp-config.php file:

define( 'WP_ALLOW_REPAIR', true );

Then go to: /wp-admin/maint/repair.php

That should take effect and automatically repair your crashed table.

answered Jul 28 '15 at 18:50

nilsree

302
1
7

Thank you very much for your answer – James Zhao Jul 28 '15 at 19:06
1

Once you've done the repair, do not forget to remove this line from your wp-config.php file. The URL /wp-admin/maint/repair.php is accessible by non authenticated users. – consuela May 16 '16 at 14:41

score 1 · Answer 4 · answered Mar 06 '19 at 18:07

I just had the same trouble. The problem was the .TMD file already existed and mysqlrepair refused to overwrite it. I removed the .TMD file and the mysqlrepair worked famously. I had to stop the process attempting to use the crashed table, then run the repair.

score 0 · Answer 5 · answered Apr 19 '18 at 12:40

For mariaDB and some other combination of OS and DB version, the file may also be located under /config/databases/[DATABASE].
Try to run as root (sudo su):

service mysql stop
myisamchk -rf /config/databases/[databasename]/wp_posts.MYI
service mysql start

score 0 · Answer 6 · answered Mar 19 '19 at 19:56

When I saw this error in phpMyadmin, I got around it by navigating to /var/lib/mysql/[database]/ and deleting the TMD file for the table I was trying to repair (not the MYI file as stated in the explanation above).

When I tried getting rid of the MYI file, the repair operation didn't work.

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

6 Answers6

Linked

Related