MySQL Forums
Forum List  »  Newbie

Re: Error Code: 126 - Incorrect key file. I am doubtful...
Posted by: Samir Abboushi
Date: June 06, 2010 09:17AM

Thanks everyone for your help. I just found additional responses that I was unaware of - my apologies...

Seems this error is caused because the temp partition was running out of disk space (annoying that the error did not suggest this as the cause). I had checked the disk space, but it seems MySQL deletes the temp files when the error is thrown, so I got fooled!

Thanks again for your posts.

>> Your query looks derived from the "compare two tables" entry at http://www.artfulsoftware.com/queries.php, is it?
Sorry Peter- don't recall where I found it...

>> you can scan one table, row by row, and search the other table for matches.
Phill - are you talking about using cursors (haven't tried that yet)?

Options: ReplyQuote




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.