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.