Hi!
Thursday, February 22, 2001, 2:22:14 PM, you wrote:
>>CONNECT udmsearchdev;
>>OPTIMIZE TABLE dict;
>>OPTIMIZE TABLE ndict2;
>>OPTIMIZE TABLE ndict3;
>>OPTIMIZE TABLE ndict4;
>>OPTIMIZE TABLE ndict5;
>>OPTIMIZE TABLE ndict6;
F> And so on.
F> But now with mysql Ver 11.11 Distrib 3.23.31, there is an syntax error :
F> "error The handler for the table doesn't support check/repair"
F> What's wrong ?
in mysql 3.23.* Optimize table should work only for myisam tables.
So you shoud convert all your table to myisam type:
alter table dict type=myisam;
...
and repeat this for all tables.
--
Regards, Sergey aka gluke.
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
