Also, you may find that check table/repair table are able to fix the problem.
See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more
information.
Greg
On Thursday 12 January 2006 08:28, Greg Fortune wrote:
> That looks a little odd. Do isam tables have a .myi file for each tabl
That looks a little odd. Do isam tables have a .myi file for each table that
stores the indexes? If so, yours appears to be missing. I would suggest you
use mysqldump to dump the table, change the ENGINE= section in the resulting
dump file, and then reload the table and data from that dump fil
I have a problem. I had to upgrade to 4.1 yesterday for an application,
and now I can't convert my old isam tables to myisam:
ALTER TABLE codes TYPE = MYISAM;
ERROR 1017 (HY000): Can't find file: 'codes.MYI' (errno: 2)
and I can't use phpmyadmin because there are isam tables. Is there any
way