2008/07/08

Deal with ERROR 126 (HY000): Incorrect key file for table in Mysql

  1. copy your data files(*.MYD) to a safe place.
  2. save your table making scripts.
  3. drop the broken table.
  4. make a brand new table with the same structure. mysql < [table making scripts]
  5. copy your data files back.
  6. myisamchk -r -q .

No comments: