marked as crashed error doesn't go away.
Posted: Fri Sep 12, 2003 5:22 am
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.
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.