Can't Repair Mysql Table
- by Pedro
Hi,
I have one table that I simply can't repair, I already try to remove the partitioning but still get this error:
alter table promo_tool_view_44 REMOVE PARTITIONING;
ERROR 1034 (HY000): Incorrect key file for table 'promo_tool_view_44'; try to repair it
I already try to repair the table but I get this reply:
repair table promo_tool_view_1;
+-----------------------------+--------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+-----------------------------+
| vad_stats.promo_tool_view_1 | repair | error | Partition p1 returned error |
| vad_stats.promo_tool_view_1 | repair | error | Corrupt |
+-----------------------------+--------+----------+-----------------------------+
2 rows in set (0.21 sec)
How can I solve this?
Thanks,
Pedro
