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 file.
When upgrading between major versions (4.0, 4.1, 5.0, 5.1, etc), it's always wise to make a full backup of the data files and a full backup of the database using mysqldump. The output from mysqldump is just SQL so it is always the safest route if you run into problems. Greg Fortune On Wednesday 11 January 2006 13:39, Anne Ramey wrote: > 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 to save the data and fix this? I know it should have been done when > upgrading to 4.0, but for some reason it wasn't. > > mysql 4.1, redhat ES3 > -- > Anne
pgp323tYrtfbt.pgp
Description: PGP signature