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 54249 Jean-Paul Le Fèvre 10/19/2005 12:29PM
Re: ERROR 126 (HY000): Incorrect key file for table 23671 Jean-Paul Le Fèvre 10/19/2005 01:19PM
Re: ERROR 126 (HY000): Incorrect key file for table 20261 Ingo Strüwing 10/20/2005 01:40AM
Re: ERROR 126 (HY000): Incorrect key file for table 17028 Jean-Paul Le Fèvre 10/20/2005 03:36PM
Re: ERROR 126 (HY000): Incorrect key file for table 16200 Ingo Strüwing 04/26/2006 04:31AM
Re: ERROR 126 (HY000): Incorrect key file for table 13971 Rock Mutchler 01/24/2007 10:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 11974 Ingo Strüwing 02/01/2007 04:31AM
Re: ERROR 126 (HY000): Incorrect key file for table 10341 Jeff Deakin 04/09/2007 06:11PM
Re: ERROR 126 (HY000): Incorrect key file for table 9287 Ingo Strüwing 05/02/2007 03:39AM
Re: ERROR 126 (HY000): Incorrect key file for table 23316 Vinayak Javaly 05/02/2007 09:06AM
Re: ERROR 126 (HY000): Incorrect key file for table 12136 Per Olesen 06/10/2007 09:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 8239 Julio Raffo 08/31/2007 02:48AM
Re: ERROR 126 (HY000): Incorrect key file for table 7391 Maria Kulagina 02/01/2008 04:05AM
Re: ERROR 126 (HY000): Incorrect key file for table 8781 Mark Reath 03/11/2008 11:09AM
Re: ERROR 126 (HY000): Incorrect key file for table 7202 Jeff Deakin 09/12/2007 08:07PM
Re: ERROR 126 (HY000): Incorrect key file for table 6397 Ingo Strüwing 09/20/2007 03:28AM
Re: ERROR 126 (HY000): Incorrect key file for table 9254 Hamish Moffatt 10/01/2007 04:59AM
Re: ERROR 126 (HY000): Incorrect key file for table 5954 Hamish Moffatt 10/08/2007 08:33AM
Re: ERROR 126 (HY000): Incorrect key file for table 7670 Ingo Strüwing 10/31/2007 09:37AM
Re: ERROR 126 (HY000): Incorrect key file for table 5158 Kristijan Burnik 12/16/2008 08:23PM
Re: ERROR 126 (HY000): Incorrect key file for table 7465 Jean-Paul Le Fèvre 11/07/2005 01:26PM
Re: ERROR 126 (HY000): Incorrect key file for table 6269 Nathan Oorloff 07/02/2007 10:51PM
Re: ERROR 126 (HY000): Incorrect key file for table 5599 Beate Schlesiona 04/26/2006 04:02AM
Re: ERROR 126 (HY000): Incorrect key file for table 7201 michael brenden 05/23/2008 04:26AM
Re: ERROR 126 (HY000): Incorrect key file for table 7167 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.