MySQL表被标记为已崩溃，并且上次(自动?)修复失败 [英] MySQL table is marked as crashed and last (automatic?) repair failed

问题描述

我正在修复此表时，服务器突然挂起，返回所有表都可以，但是此表显示为正在使用"，并且在尝试修复时此表无法进行.

I was repairing this table suddenly server hanged and when I returned back all tables are ok but this one showing 'in use' and when I try to repair it doesn't proceed.

错误144-表'./extas_d47727/xzclf_ads'被标记为已崩溃，并且上次(自动)修复失败

ERROR 144 - Table './extas_d47727/xzclf_ads' is marked as crashed and last (automatic?) repair failed

我该怎么办?

推荐答案

如果您的MySQL进程正在运行，请停止它.在Debian上:

If your MySQL process is running, stop it. On Debian:

sudo service mysql stop

转到您的数据文件夹.在Debian上:

Go to your data folder. On Debian:

cd /var/lib/mysql/$DATABASE_NAME

尝试运行:

myisamchk -r $TABLE_NAME

如果这不起作用，您可以尝试:

If that doesn't work, you can try:

myisamchk -r -v -f $TABLE_NAME

您可以再次启动MySQL服务器.在Debian上:

You can start your MySQL server again. On Debian:

sudo service mysql start

这篇关于MySQL表被标记为已崩溃，并且上次(自动?)修复失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！