Can't Repair Mysql Table
Posted
by Pedro
on Server Fault
See other posts from Server Fault
or by Pedro
Published on 2010-03-08T10:45:46Z
Indexed on
2010/03/08
10:51 UTC
Read the original article
Hit count: 701
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
© Server Fault or respective owner