Hello.
Have you tried mysql_convert_table_format script? "Spencer Yost" <[EMAIL PROTECTED]> wrote: > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
