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