Fix SQL error Index for table 'user_db' is corrupted, try to repair it
|I am receiving an SQL error: Index for table 'user_db' is corrupted, try to repair it. I am not sure what went wrong.|
How can I fix this ?
The error "Index for table '' is corrupted, try to repair it" is related to the specific table, which for some reason became corrupted, as mentioned in the notification. This problem can be solved using TABLE REPAIR. You can try to fix it with the first solution and if it will not work, you can try the second one with USE_FRM.
Please note that using of these solutions to repair the table, may cause the data loss under some circumstances. It is recommended to make a backup of a table before performing a table repair operation. I used TABLE REPAIR on localhost, where the data loss may not be so serious.
Regular table repair:
TABLE REPAIR table_name;
Table repair with using USE_FRM:
TABLE REPAIR table_name USE_FRM;
|Qualcomm Snapdragon processors - list of mobile phones brands|
|How to calculate how many Man Days are 3 Man Hours ?|
|How to calculate inverse currency exchange rate ?|
|How to add side by side rows in excel pivot table ?|
|List of the best Free web hosting sites with subdomain|
|What does @ mean before PHP function ? PHP mail vs. @mail|
|Free email accounts with large or unlimited storage capacity|