Troubleshooting "Table x is marked as crashed and should be repaired"
This error appears when MySQL database needs to be repaired. It could happen with MyISAM type of tables.
Quick solution
Try to run this query using a database administration tool like phpMyAdmin:
sql
- REPAIR TABLE `table_name`;
table_name is table which marked as crashed. Detailed solution
There is a long way to fix this. But you can receive a detailed instructions in MySQL documentation, see 5.10.4.3. How to Repair Tables.
Stop Apache and MySQL services.
Start → Run → type
cmd, hit[Enter]Go to directory
mysql/bin:
bash
- c:\> cd "c:/Glossword WAMP/mysql5/bin"
Open MySQL documentation http://dev.mysql.com/doc/refman/5.0/en/repair.html
Stage 1: Checking your tables
bash
- myisamchk.exe -e "c:/Glossword WAMP/mysql5/data/glossword1_8/gw_xdtsffjq"
