I just upgraded a server to MySQL 4.1.4. I was at 4.0.8 - everything worked perfect at 4.0.8
However, since the upgrade, a few dozen tables in a few older databases are apparently still in ISAM format. The tables now misbehave when trying to access them(marked in use, error out, trash the server, you name it). This is especially troubling because one of the tables is mysql.user so none of my customer's programs work )-; downgrading back to 4.0.8 for other reasons unfortunately so I have to slog through this. What is infuriating is isamchk reports that each table is in fine shape(with an accurate record count), but no other utilities, like myisamchk, mysqldump, will touch the table . Likewise, none of the SQL statements like REPAIR table (with or without use_frm) or ALTER table work. All of the utilities & statements, without hardly an exception, complain that the MYI file is missing. It is missing and never existed for these tables as I have backups going back years and they are on none of them. My guess is these table files appear on the surface to these utilities to be MyISAM(header flag or something) file, but are really ISAM files. Any help if figuring out how to get the data out of the files and into newer tables would be APPRECIATED Spencer Yost Sundance Consulting 336.287.8017 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
