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?
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...
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.