MySQL said: #1194 - Table 'tablename' is marked as crashed and should be repaired MySQL said: #1194 - Table 'tablename' is marked as crashed and should be repaired sql sql

MySQL said: #1194 - Table 'tablename' is marked as crashed and should be repaired


First of all - there are many reasons for a crashed table.

  • harddisk failure
  • sudden server reboot
  • server crash
  • firmware problems (raid controller or bios)
  • defects in the cabling
  • etc.

A repair with phpmyadmin does basically the same as the mysqlrepair commandline. I would suggest to repair everything on command line:

mysqlrepair -A --auto-repairmysqlrepair -A -o

Or start a test:

mysqlrepair -A -c


If you don't have commandline tools needed, and reason for crash is most likely is MYSQL itself, run this from MYSQL to repair a table:

REPAIR TABLE db_name.table_name;


Use:

mysqlcheck -u root -p --auto-repair --check --all-databases(Password prompted)

Enter MySQL password for user root and everything is done.