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>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
