List:General Discussion« Previous MessageNext Message »
From:Inigo Medina Date:November 20 2012 6:08pm
Subject:Re: mysqldump Got error 1034 Incorrect key file for table
View as plain text  
On Tue, 20 Nov 2012, Ricardo Barbosa wrote:

> Hi all.
>
> I'm trying to do a recover on a table for a client, with the following message
>
> root@falcon:~# mysqldump -u root -pXXXXXXX database
> -- MySQL dump 10.13  Distrib 5.1.30, for pc-linux-gnu (i686)
> --
> -- Host: localhost    Database: database
> -- ------------------------------------------------------
> -- Server version       5.1.30
>
> /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
> /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
> /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
> /*!40101 SET NAMES utf8 */;
> /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
> /*!40103 SET TIME_ZONE='+00:00' */;
> /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
> /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
> /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
> /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
> mysqldump: Got error: 1034: Incorrect key file for table 'table1'; try to repair it
> when using LOCK TABLES
> root@falcon:~#
>
> I'm trying recover with
>
> mysql> check table table1;
>
> +-----------------+-------+----------+-----------------------------------------------------------+
> | Table           |
> Op    | Msg_type |
> Msg_text                                                 
> |
>
> +-----------------+-------+----------+-----------------------------------------------------------+
> | database.table1 | check | Error    | Incorrect key file for table
> 'table1'; try to repair it |
> | database.table1 | check | error    |
> Corrupt                                                  
> |
>
> +-----------------+-------+----------+-----------------------------------------------------------+
> 2 rows in set (0.00 sec)
>
> mysql> repair table table1;
>
> +-----------------+--------+----------+-----------------------------------------------------------+
> | Table           |
> Op     | Msg_type |
> Msg_text                                                 
> |
>
> +-----------------+--------+----------+-----------------------------------------------------------+
> | database.table1 | repair | Error    | Incorrect key file for table
> 'table1'; try to repair it |
> | database.table1 | repair | error    |
> Corrupt                                                  
> |
>
> +-----------------+--------+----------+-----------------------------------------------------------+
> 2 rows in set (0.00 sec)
>
> mysql> lock table table1 write;
> ERROR 1034 (HY000): Incorrect key file for table 'table1'; try to repair it
> mysql>
>
>
> Trying repair with myisamchk and mysqlcheck
>
> root@Falcon:~# mysqlcheck -r database table1 -u root -pXXXX database.table1
> Error    : Incorrect key file for table 'table1'; try to repair it
> error    : Corrupt
> root@falcon:~#
>
> root@Falcon:~# cd /data/mysql/database
> root@Falcon:/data/mysql/database# myisamchk -r *.MYI
> - recovering (with sort) MyISAM-table 'table1.MYI'
> Data records: 0
> - Fixing index 1
>
> ---------
>
> Any idea.

Try to start with MySQL advices for such cases:
http://dev.mysql.com/doc/refman/5.6/en/myisam-repair.html>
> Regards.
Thread
mysqldump Got error 1034 Incorrect key file for tableRicardo Barbosa20 Nov
  • Re: mysqldump Got error 1034 Incorrect key file for tableInigo Medina20 Nov