Hi there,
I am filling my database with records for quite a while now, but suddenly I get a lot of error messages when trying to save a new record. The message always starts with '126 incorrect key file' but is not always the same. When I trie to save the same record again, most of the times it works. But it is annoying anyway. Can somebody tell me how to solve this?
A few examples of the complete error messages I got today:
126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROM i6zjk_js_res_record
126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROMi6zjk_js_res_fields126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROMi6zjk_js_res_record_values`
Thanks,
Manon
Question
Announcement
Conversation
Idea
Praise
Problem
Reviewed
Open
Hi there,
I am filling my database with records for quite a while now, but suddenly I get a lot of error messages when trying to save a new record. The message always starts with '126 incorrect key file' but is not always the same. When I trie to save the same record again, most of the times it works. But it is annoying anyway. Can somebody tell me how to solve this?
A few examples of the complete error messages I got today:
126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROM
i6zjk_js_res_record 126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROMi6zjk_js_res_fields126 Incorrect key file for table '/tmp/#sql_3ee2_0.MYI'; try to repair it SQL=SHOW FULL COLUMNS FROMi6zjk_js_res_record_values`Thanks, Manon