Page 1 of 1

marked as crashed error doesn't go away.

Posted: Fri Sep 12, 2003 5:22 am
by shirokuma
I have a DOS batch job that uses mysqlimport to import some text files into mysql tables. The tables are constantly being added to a little bit at a time.

I am getting errors like this:

mysqlimport.exe: Error: Can't open file: 'sec.MYI'. (errno: 145), when using table: sec

I used to myisamchk to repair the tables the result shows that the table has been repaired but the error won't go away. When I use repair table from a mysql front end it returns that the table is okay but I am still getting the same error.

Is there any way to clear the table is marked as crashed flag so that I can continue working?

I would appreciate any help you can give me.

Posted: Sun Sep 14, 2003 10:21 am
by JAM
Dont know as you allready tried to repair it the ordinary way. I fyou want, you can try to copy over the structure and content to a temporary db, drop the original one. Then copy the contents form the recently copied table back...

Posted: Tue Sep 16, 2003 9:13 am
by shirokuma
Thanks for the help. I found the root of my problem - me. It was just a stupid user error on my part. I was fixing the tables on one server and trying to upload to an entirely different server.

Thanks,
PRO