MySQL in Linux can not REPAIR table repair tables Solution

REPAIR table Syntax

REPAIR table ' table_name ' repair form

REPAIR table is used to repair damaged tables

Using in Linux

REPAIR TABLE ' table_name ' pre_forum_thread

Tips

Xt.pre_forum_thread Repair Error 1 when fixing table

Xt.pre_forum_thread repair Error Can ' t change ownership of the ' file '/usr/local/mys ...

Xt.pre_forum_thread Repair Status Operation failed

Solutions

CD Past:/var/lib/mysql/(mysql default installation path under Linux) ensure under MySQL file

Chown-r Mysql:mysql *

You can REPAIR TABLE in a tool like phpMyAdmin.

-------------------------------------

A previous system has been showing a table exception, phpMyAdmin fix also prompts "Can" t change ownership of the file '/xxx/xxx. MyD ' (errcode:1–operation not permitted). The problem was solved for the time being, but soon it was abnormal, so we started to try to solve the problem. The problem was found to be resolved due to an exception to the file permissions setting and the unification of its permissions and other files of the same directory. The specific methods are as follows:

Enter the directory where the file is located and execute the instruction:

Ls-l

It is generally inconsistent to see whether the file has the same permissions as the other files that are currently in place ~ ~

At this point, you will pass:

Chown-r User xxx. MyD

Chgrp-r user group XXX. MyD

chmod permission xxx. MyD

To modify the user rights and user groups in the file to match the other files in the directory. The code above, the Permissions section is similar to the 777 settings, specifically do not understand the words of Google to go.

After the modification is complete, the table can be repaired by phpMyAdmin.