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.
