База на знаења

I GET THE ERROR: TABLE MATOMO_LOG_X IS MARKED AS CRASHED AND LAST (AUTOMATIC?) REPAIR FAILED. Print

  • 0

When you get the error Table sivehost_log_visit is marked as crashed and last (automatic?) repair failed. it means that the Mysql tables got partially corrupt and must be repaired. This problem may occur for various reasons (such as missing space on the disk) but it should occur very rarely.

It is possible to solve this problem by connecting to your Mysql server and executing the following queries:

REPAIR TABLE sivehost_log_visit;

(replace sivehost_log_visit with the name of your crashed table as it appears in the error message)

This may not work, in which case use the following solution:

cd /var/lib/mysql/your_sivehost_database
myisamchk -r -v -f ./sivehost_log_visit

Your tables should now be repaired and your database up and running!


Дали Ви помогна овој одговор?
Back