Thursday, November 17, 2016

How to fix “table is marked as crashed and should be repaired”

http://dtbaker.net/web-development/how-to-fix-table-is-marked-as-crashed-and-should-be-repaired/

Power outage or a buggy mysql version could cause this error to appear:
Stops any php scripts from running etc..

mysql: Table ‘database/table’ is marked as crashed and should be repaired

To fix this, I ran this command via a shell:
$ mysqlcheck --all-databases -uroot -p
enter the root password, and it goes through checking all database tables for issues. hopefully fixing along the way 🙂
You may have to change root to whatever database username you have available (ie: whatever you use to login to phpmyadmin)
It any show the error, run this sql:
$ mysql -uroot -p databasename
  REPAIR TABLE tablename;
Or just jump into phpmyadmin and click on repair