Bug #34645 mysqlcheck -r does not work on MySQL 5.0.27 Innodb Storage Engine.
Submitted: 18 Feb 2008 20:27 Modified: 19 Feb 2008 16:00
Reporter: Bogdan Pytlik Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S5 (Performance)
Version:MySQL 5.0.27 OS:Windows
Assigned to: CPU Architecture:Any

[18 Feb 2008 20:27] Bogdan Pytlik 
Description:
We upgraded our customer from MySQL 4.0.26 ISAM format to MySQL 5.0.27 Innodb format. Everything works ok except mysqlcheck -r. mysqlcheck -c works ok.

Below is the error we receive when we run mysqlcheck -r.

C:\mysql\bin>mysqlcheck -r -uroot -proot replixdb
replixdb.users
note     : The storage engine for the table doesn't support repair
replixdb.server
note     : The storage engine for the table doesn't support repair

Is there a workaround I can give my customer?
Is this an issue because we went from ISAM to Innodb?

How to repeat:
see above
[19 Feb 2008 1:16] MySQL Verification Team 
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html

" The MyISAM storage engine supports all four statements, so mysqlcheck can be used to perform all four operations on MyISAM tables. Other storage engines do not necessarily support all operations. In such cases, an error message is displayed. For example, if test.t is a MEMORY table, an attempt to check it produces this result:

shell> mysqlcheck test t
test.t
note     : The storage engine for the table doesn't support check

Caution"
[19 Feb 2008 16:00] Bogdan Pytlik 
Is there an equivalent command to mysqlcheck -r that will work with MySQL 5.0.27 Innodb Storage Engine?

If not is there a way to do a repair using one of the MySQL Gui Tools?

Please reply to rmacchia@softlinx.com
[3 Mar 2008 13:09] Susanne Ebrecht 
Bug system is not the right platform to ask support questions. Please ask your question at:
http://forums.mysql.com