MySQL Forums :: MyISAM :: ERROR 126 (HY000): Incorrect key file for table


Advanced Search

Re: ERROR 126 (HY000): Incorrect key file for table
Posted by: Jean-Paul Le Fèvre ()
Date: October 19, 2005 01:19PM

A few more remarks :

- I've been able to recreate one more table by removing the unique keyword on the columns which had this keyword.
- changing the engine from MyISAM to Memory or InnoDB fixes the problem. It could be a workaround.

Options: ReplyQuote


Subject Views Written By Posted
ERROR 126 (HY000): Incorrect key file for table 54364 Jean-Paul Le Fèvre 10/19/2005 12:29PM
Re: ERROR 126 (HY000): Incorrect key file for table 23715 Jean-Paul Le Fèvre 10/19/2005 01:19PM
Re: ERROR 126 (HY000): Incorrect key file for table 20301 Ingo Strüwing 10/20/2005 01:40AM
Re: ERROR 126 (HY000): Incorrect key file for table 17056 Jean-Paul Le Fèvre 10/20/2005 03:36PM
Re: ERROR 126 (HY000): Incorrect key file for table 16231 Ingo Strüwing 04/26/2006 04:31AM
Re: ERROR 126 (HY000): Incorrect key file for table 13997 Rock Mutchler 01/24/2007 10:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 11996 Ingo Strüwing 02/01/2007 04:31AM
Re: ERROR 126 (HY000): Incorrect key file for table 10366 Jeff Deakin 04/09/2007 06:11PM
Re: ERROR 126 (HY000): Incorrect key file for table 9305 Ingo Strüwing 05/02/2007 03:39AM
Re: ERROR 126 (HY000): Incorrect key file for table 23357 Vinayak Javaly 05/02/2007 09:06AM
Re: ERROR 126 (HY000): Incorrect key file for table 12176 Per Olesen 06/10/2007 09:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 8261 Julio Raffo 08/31/2007 02:48AM
Re: ERROR 126 (HY000): Incorrect key file for table 7414 Maria Kulagina 02/01/2008 04:05AM
Re: ERROR 126 (HY000): Incorrect key file for table 8795 Mark Reath 03/11/2008 11:09AM
Re: ERROR 126 (HY000): Incorrect key file for table 7220 Jeff Deakin 09/12/2007 08:07PM
Re: ERROR 126 (HY000): Incorrect key file for table 6421 Ingo Strüwing 09/20/2007 03:28AM
Re: ERROR 126 (HY000): Incorrect key file for table 9297 Hamish Moffatt 10/01/2007 04:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 5975 Hamish Moffatt 10/08/2007 08:33AM
Re: ERROR 126 (HY000): Incorrect key file for table 7692 Ingo Strüwing 10/31/2007 09:37AM
Re: ERROR 126 (HY000): Incorrect key file for table 5182 Kristijan Burnik 12/16/2008 08:23PM
Re: ERROR 126 (HY000): Incorrect key file for table 7480 Jean-Paul Le Fèvre 11/07/2005 01:26PM
Re: ERROR 126 (HY000): Incorrect key file for table 6298 Nathan Oorloff 07/02/2007 10:51PM
Re: ERROR 126 (HY000): Incorrect key file for table 5624 Beate Schlesiona 04/26/2006 04:02AM
Re: ERROR 126 (HY000): Incorrect key file for table 7236 michael brenden 05/23/2008 04:26AM
Re: ERROR 126 (HY000): Incorrect key file for table 7194 Kristijan Burnik 12/16/2008 08:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.