Re: repair fails - don't know why
I checked the sources (4.0.26). Errno 130 is defined as HA_ERR_NOT_A_TABLE. This error is only emitted in myisam/mi_open.c: mi_open() (and in myisamchk, which is not relevant here). HA_ERR_NOT_A_TABLE is emitted if the .MYI file could be opened, but is too short (24 bytes) or the first four bytes are not the magic number for an index file (myisam_file_magic, defined in myisam/mi_static.c).
It is quite clear from the sources that there must be a .MYI file. But whatever I tried to put into my .MYI file, REPAIR TABLE t1 USE_FRM; always succeeded. There seems to be something weird happening with your system.
Subject
Views
Written By
Posted
4038
July 26, 2005 09:59PM
2377
July 27, 2005 06:11AM
2395
July 27, 2005 08:28AM
Re: repair fails - don't know why
2259
July 28, 2005 02:31AM
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.