Hello.
Tools for MyISAM tables won't help you with InnoDB. See:
http://dev.mysql.com/doc/mysql/en/gone-away.html
iv <iv@stripped> wrote:
> 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
>
> Thanks in advance,
> iv <iv at fnet dot pl>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
