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 iñ
Regards.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql