Error 1194: Table is marked as crashed and should be repaired

Error Code	SQLSTATE	Error	Description
1194	HY000	ER_CRASHED_ON_USAGE	Table '%s' is marked as crashed and should be repaired

Possible Causes and Solutions

This error occurs, in particular to MyISAM, Aria, Archive or CSV tables, if the table is marked as crashed. This can occur for a number of reasons, for example:

• running out of disk space

• sudden shutdown while the table was in use

Fixing the problem can usually be done by running a REPAIR TABLE statement, or one of the similar scripts, aria_chk, myisamchk or mariadb-check.

_{This page is licensed: CC BY-SA / Gnu FDL}