Bug #892 myisamchk issues with tables without index and compressed tables
Submitted: 22 Jul 2003 14:54 Modified: 12 Aug 2003 7:01
Reporter: Miguel Solorzano Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S1 (Critical)
Version: Ver 2.6 OS:Microsoft Windows (Windows)
Assigned to: Sergei Golubchik

[22 Jul 2003 14:54] Miguel Solorzano
When issued the below command for all tables within a database...
myisamchk --recover --analyze --sort-index --sort-records=1 --verbose F:\mysql\data\test\*.MYI

First issue: for a table without an index. It displays the below error:

myisamchk: error: Can't sort table 'F:\mysql\data\test\billtype.MYI' on key 1;
No such key

and lets marked the table as crashed.

Second issue: the process stops once a compressed table is encountered.
I would prefer myisamchk to just continue with the next table.

How to repeat:
Create a database with tables without index and tables compressed.
Apply the command showed.
[30 Jul 2003 5:05] Sinisa Milivojevic
One more problem.

When :

myisamchk -r -a 

is invoked, then only first one is executed and second never.
[12 Aug 2003 7:01] Sergei Golubchik
"marked the table as crashed." - fixed in 4.0.15
other two issues - cannot repeat.