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

Related posts about mysql

Related posts about mysql-server