From: Date: April 24 2005 9:46pm
Subject: Re: crushed innodb table
List-Archive: http://lists.mysql.com/mysql/183031
Message-Id: <000c01c54906$42760770$bf22de50@koticompaq>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="Windows-1252";
	reply-type=original
Content-Transfer-Encoding: 7bit

iv,

----- Original Message ----- 
From: "iv" <iv@stripped>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 21, 2005 9:04 PM
Subject: crushed innodb table


> hi
> I've got a problem with a crushed innodb table (as i think)
>
> When I'm trying to make a backup, something like this appears:
> mysqldump: Error 2013: Lost connection to MySQL server during query
> when dumping table `adstats` at row 34342;
>
> trying to check table:
> mysql> check table adstats extended;
> ERROR 2013 (HY000): Lost connection to MySQL server during query
>
> repairing that:
> mysql> repair table adstats;
> phpads.adstats | repair | note     | The handler for the table doesn't
> support repair
> the same is going on with "repair table ads_adstats USE_FRM"
>
> I have also tried mysqlchk and myisamchk with -r and -o options. It
> didn't work, sinse that "adstats"  is the innodb  table..
> myisamchk: error: 'adstats.frm' is not a MyISAM-table
> # mysqlcheck -r phpads adstats
> note     : The handler for the table doesn't support repair
>
> Any ideas how to deal with the problem? I have read through about a
> hundred threads, but i haven't find a method of repairing innodb tables;
> and only in one place I've found a problem similar to mine, but without
> a solution

please look in the .err log to see what is the problem.

http://dev.mysql.com/doc/mysql/en/forcing-recovery.html

> Thanks in advance,
> iv <iv at fnet dot pl>

Best regards,

Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php

Order MySQL Network from http://www.mysql.com/network/