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 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
pgpvBPtiiNNqf.pgp
Description: PGP signature