[SOLVED] MySQL table repair error "Can't create new tempfile: '/*****/filename.TMD"

[SOLVED] MySQL table repair error "Can't create new tempfile: '/*****/filename.TMD"

In very rare conditions this error occurs while repairing your MySQL database table or whole database. This error occurs when you are trying to repair any crashed database table or database itself. Mostly, this occurs when WordPress "wp-posts" table crashed and you try to repair it. It is quite frustrating for the person who is new in this industry. But, now you don't have to stress more and you can chill out as resolving this error is quite simple and easy.
Before we begin, let's first understand the error and reason behind it and then we will see it's solution.

When this error occurs ?
This error occurs while repairing your MySQL database table or whole database which was crashed earlier. Mostly for WordPress databases and tables.

Why this error occurs ?
There may be two reason behind this error :
1) Either, you are running short of disk space due to which this error is showing.

2) Or, your Wp-config file is misconfigured due to which table is not repairing properly.

How to resolve it ?
Well, there is very easy and simple solution to repair your crashed table. You will going to need root shell access for this.
You have to login as root in shell access and just run this command :
----
# myisamchk -r -f tables.MYI
----
This will surely work for you.

If you have any other solution or suggestion you can comment below.:):):)
Author
bhawanisingh
Views
7,755
First release
Last update
Rating
0.00 star(s) 0 ratings
Top