> > > Brian J.S. Miller wrote: > >> >>Walt, >> >>The tables are ISAM type. These are some seriously old tables >> (originally >>from version 3.21) and were never updated to type MyISAM. Despite >>frequent updates to mysqld. >> >>There is a program isamchk which is similar to myisamchk, but it returns >>the error "___ is not a ISAM-table." >> >>I have read and re-read the man pages for this utility and cannot get it >>to spit out anything more than the error listed above. >> >>Anyone else got an idea? This is killing me. >>Brian >> >> >> > Make sure you are running isamchk on th .ISM files, and that the user > running isamchk > has read and write privileges for these files and their directory. > > If these files did not come from a linux box of the same architecture, > you may have to go back to a > duplicate of the old machine to convert or dump them. > >
When you say "same architecture" ...as long as it's i686 it should work right? The box hasn't changed, but the drive and filesystem have. I was running this on a 36.7G ultra160 drive. I replaced it with an older 18G drive, re-installed the OS onto this drive, and tried to copy the files. The CPU, memory, etc. have stayed the same. The old install was reiserfs but the new one is ext3. That shouldn't make a difference either right? As for your other suggestion, I was definitely running isamchk on the .ISM files. What's weirdest is that 67 of the 76 tables are working. There are just 9 that won't work. They're the 9 biggest tables, however (which is the weird part). Brian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
