marked as crashed error doesn't go away.

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
shirokuma
Forum Newbie
Posts: 8
Joined: Fri Jun 13, 2003 4:45 am
Location: Japan

marked as crashed error doesn't go away.

Post 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.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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...
shirokuma
Forum Newbie
Posts: 8
Joined: Fri Jun 13, 2003 4:45 am
Location: Japan

Post 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
Post Reply