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/
