Maison > Article > développement back-end > 优化表后出现了is marked as crashed and last (automatic?) repair failed解决办法
优化表后出现了is marked as crashed and last (automatic?) repair failed
今天想优化一下表,优化之后出现了如下问题:
<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> mysql> OPTIMIZE TABLE jo_mailqueue; +---------------------+----------+----------+-------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +---------------------+----------+----------+-------------------------------------------------------------+ | jobour.jo_mailqueue | optimize | error | 1 when fixing table | | jobour.jo_mailqueue | optimize | Error | Can't change ownership of the file '/usr/local/mysql/data/jobour/jo_mailqueue.MYD' (Errcode: 1) | | jobour.jo_mailqueue | optimize | status | Operation failed | +---------------------+----------+----------+---------------------------------------------------