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>
