MySQL Forums
Forum List  »  Newbie

Re: ERROR 1030: Got error 127 from table handler
Posted by: Puiu Hrenciuc
Date: September 18, 2004 09:32PM

Your databases are MyISAM and the table(s) got corrupted.

Open a command prompt.

go to [INSTALL DIR]\bin\
and enter : myisamchk -r [INSTALL DIR]/data/mysql/*.MYI

[ == for eg . if install dir is "c:\mysql" do ==

C: [ENTER]
CD \mysql\bin\ [ENTER]
myisamchk -r c:/mysql/data/mysql/*.MYI [ENTER]

]

this should fix your MySQL tables

This is for Windows version, if you have *ix, is almost the same.

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 1030: Got error 127 from table handler
September 18, 2004 09:32PM


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.