C'mon, guys, there's gotta be someone who knows something about this. :) Anyone? Anyone? Bueller? Bueller? I even did a complete mysqldump (from the 5.0.77 mysqld) and imported it that way. To no luck, alas.
Thanks, - Mark -----Original Message----- From: Mark [mailto:ad...@asarian-host.net] Sent: zaterdag 25 april 2009 2:34 To: mysql@lists.mysql.com Subject: Error : Incorrect key file for table 'X' Odd. I just painstakingly upgraded to MySQL 5.1.34, coming from 5.0.77. So, I run: "/usr/local/bin/mysql_upgrade", and get these all over the place (see below; just a few lines: the error list is too long to post in whole). So, accomodating MySQL, I run: /usr/local/bin/myisamchk --force --extend-check --update-state -O key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M /var/db/mysql/*/*.MYI Makes no difference, though. All the tables are unusable now (thank God for Vmware!). But obviously, I can't take it to the producton server like this (FreeBSD). Anyone any idea what's happening? Thanks, - Mark Repairing tables albatross.banned Error : Incorrect key file for table 'banned'; try to repair it error : Corrupt albatross.bridge Error : Incorrect key file for table 'bridge'; try to repair it error : Corrupt albatross.categories Error : Incorrect key file for table 'categories'; try to repair it error : Corrupt albatross.comments Error : Incorrect key file for table 'comments'; try to repair it error : Corrupt albatross.config Error : Incorrect key file for table 'config'; try to repair it error : Corrupt albatross.dict Error : Incorrect key file for table 'dict'; try to repair it error : Corrupt albatross.ecards Error : Incorrect key file for table 'ecards'; try to repair it error : Corrupt albatross.exif Error : Incorrect key file for table 'exif'; try to repair it error : Corrupt albatross.favpics Error : Incorrect key file for table 'favpics'; try to repair it error : Corrupt albatross.filetypes Error : Incorrect key file for table 'filetypes'; try to repair it error : Corrupt albatross.hit_stats Error : Incorrect key file for table 'hit_stats'; try to repair it error : Corrupt albatross.plugins Error : Incorrect key file for table 'plugins'; try to repair it error : Corrupt Etc, etc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
