Jump to content

Archived

This topic is now archived and is closed to further replies.

dane08

Cant open a table

Recommended Posts

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?

Share this post


Link to post
Share on other sites

the table is currupted. try

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]REPAIR TABLE searchindex [!--sql2--][/div][!--sql3--]

Share this post


Link to post
Share on other sites

[!--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 :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.