From: Ricardo Barbosa
Date: November 20 2012 2:11pm
Subject: mysqldump  Got error 1034 Incorrect key file for table
List-Archive: http://lists.mysql.com/mysql/228665
Message-Id: <1353420678.2524.YahooMailNeo@web163603.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="-1090023523-1599868360-1353420678=:2524"

---1090023523-1599868360-1353420678=:2524
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi all.=0A=0AI'm trying to do a recover on a table for a client, with the f=
ollowing message=0A=0Aroot@falcon:~# mysqldump -u root -pXXXXXXX database=
=0A-- MySQL dump 10.13=A0 Distrib 5.1.30, for pc-linux-gnu (i686)=0A--=0A--=
 Host: localhost=A0=A0=A0 Database: database=0A-- -------------------------=
-----------------------------=0A-- Server version=A0=A0=A0=A0=A0=A0 5.1.30=
=0A=0A/*!40101 SET @OLD_CHARACTER_SET_CLIENT=3D@@CHARACTER_SET_CLIENT */;=
=0A/*!40101 SET @OLD_CHARACTER_SET_RESULTS=3D@@CHARACTER_SET_RESULTS */;=0A=
/*!40101 SET @OLD_COLLATION_CONNECTION=3D@@COLLATION_CONNECTION */;=0A/*!40=
101 SET NAMES utf8 */;=0A/*!40103 SET @OLD_TIME_ZONE=3D@@TIME_ZONE */;=0A/*=
!40103 SET TIME_ZONE=3D'+00:00' */;=0A/*!40014 SET @OLD_UNIQUE_CHECKS=3D@@U=
NIQUE_CHECKS, UNIQUE_CHECKS=3D0 */;=0A/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=
=3D@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=3D0 */;=0A/*!40101 SET @OLD_SQL=
_MODE=3D@@SQL_MODE, SQL_MODE=3D'NO_AUTO_VALUE_ON_ZERO' */;=0A/*!40111 SET @=
OLD_SQL_NOTES=3D@@SQL_NOTES, SQL_NOTES=3D0 */;=0Amysqldump: Got error: 1034=
: Incorrect key file for table 'table1'; try to repair it when using LOCK T=
ABLES=0Aroot@falcon:~#=0A=0AI'm trying recover with=0A=0Amysql> check table=
 table1;=0A+-----------------+-------+----------+--------------------------=
---------------------------------+=0A| Table=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
| Op=A0=A0=A0 | Msg_type | Msg_text=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=0A+-----------------+-------+----------=
+-----------------------------------------------------------+=0A| database.=
table1 | check | Error=A0=A0=A0 | Incorrect key file for table 'table1'; tr=
y to repair it |=0A| database.table1 | check | error=A0=A0=A0 | Corrupt=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=
=0A+-----------------+-------+----------+----------------------------------=
-------------------------+=0A2 rows in set (0.00 sec)=0A=0Amysql> repair ta=
ble table1;=0A+-----------------+--------+----------+----------------------=
-------------------------------------+=0A| Table=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0 | Op=A0=A0=A0=A0 | Msg_type | Msg_text=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 |=0A+-----------------+--------+---=
-------+-----------------------------------------------------------+=0A| da=
tabase.table1 | repair | Error=A0=A0=A0 | Incorrect key file for table 'tab=
le1'; try to repair it |=0A| database.table1 | repair | error=A0=A0=A0 | Co=
rrupt=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=
=A0=A0 |=0A+-----------------+--------+----------+-------------------------=
----------------------------------+=0A2 rows in set (0.00 sec)=0A=0Amysql> =
lock table table1 write;=0AERROR 1034 (HY000): Incorrect key file for table=
 'table1'; try to repair it=0Amysql>=0A=0A=0ATrying repair with myisamchk a=
nd mysqlcheck=0A=0Aroot@Falcon:~# mysqlcheck -r database table1 -u root -pX=
XXX database.table1=0AError=A0=A0=A0 : Incorrect key file for table 'table1=
'; try to repair it=0Aerror=A0=A0=A0 : Corrupt=0Aroot@falcon:~#=0A=0Aroot@F=
alcon:~# cd /data/mysql/database=0Aroot@Falcon:/data/mysql/database# myisam=
chk -r *.MYI=0A- recovering (with sort) MyISAM-table 'table1.MYI'=0AData re=
cords: 0=0A- Fixing index 1=0A=0A---------=0A=0AAny idea.=0A=0ARegards.
---1090023523-1599868360-1353420678=:2524--