dane08 Posted December 6, 2005 Share Posted December 6, 2005 Hi! My problem is about a table that keeps on giving me an error 145 even if i drop it and remake it again and again. The actual error that is receive is: "Can't open file: 'searchindex.MYD'. (errno: 145)". What i mean by again and again is i after I remade the table and them make some inserts into it, then after several days i *again* get the same error. I have encountered this so many times and only in this particular table. i even rebuild the whole database before but untill now i get that error. What should i do? Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted December 6, 2005 Share Posted December 6, 2005 the table is currupted. try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--] Quote Link to comment Share on other sites More sharing options...
dane08 Posted December 7, 2005 Author Share Posted December 7, 2005 [!--quoteo(post=325086:date=Dec 6 2005, 11:24 AM:name=ryanlwh)--][div class=\'quotetop\']QUOTE(ryanlwh @ Dec 6 2005, 11:24 AM) 325086[/snapback][/div][div class=\'quotemain\'][!--quotec--] the table is currupted. try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--] i just did that and it worked. I hope it wont get corrupted again. tnx Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.