I have a MySQL 5.1.63 server and two uncorrectable MyISAM table. I tried the following ways to repair it:
- mysqlcheck -r db.tbl1
- ALTER TABLE db.tbl1 ENGINE=InnoDB
- myisamchk -re /var/lib/mysql/db/tbl1
- myisamchk -oe /var/lib/mysql/db/tbl1
The mysqlcheck and ALTER TABLE show me the following error:
Error : Incorrect key file for table 'tbl1'; try to repair it error : Corrupt
The myisamchk (both version) says:
- recovering (with sort) MyISAM-table 'tbl1' Data records: 232311 - Fixing index 1 - Fixing index 2 - Fixing index 3
So it seems fixed the table, but in the real it is not being fixed.
This table is relative new (2008) and not a migrated table (so it is not migrated from older MySQL versions, like 4.x).
Can anyone give me any idea how can I really fix this table? It causes problems in mysqldump too.