xpredo script

العودة   منتدى نيو حب > منتديات الحاسب والاتصالات > تطوير المواقع والمنتديات > منتدى تطوير المواقع

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

منتدى تطوير المواقع

26-09-2017, 01:07 PM
islammrk
 
Post Mysql table repair failed: “Can't create new tempfile”

I found that 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]/TABLE .TMD'

repair status Operation failed

I tried to run the following command in shell:

myisamchk -r -f TABLE .MYI

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

i fix this problem?

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

In my CentOS system, I changed direction to /var/lib/mysql/[database]/and found table.MYI , TABLE.tmp

After removing this file, repair was successful.
من مواضيع : islammrk Mysql table repair failed: “Can't create new tempfile”
 

الكلمات الدلالية (Tags)
سوق،الكترونى،للبرامج

أدوات الموضوع

الانتقال السريع

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

الساعة الآن 09:27 PM.