[RESOLVED] I cant open one of my tables

[dane]

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?

[Andrew_W_Peace]

You've tried completely deleting everything? (including the username, etc)

If you've tried deleting everything and it's still not working, you should contact your server administrator.

[dane]

no, only the the database where searchindex table is in.

do i really need to do that? im using root.

[cahva]

Have you tried REPAIR? Sometimes the tables get scrambled.

Just use REPAIR TABLE searchindex;

EDIT: Sorry about that. Use that repair table on that table which resides in database searchindex

[dane]

i just did it now.. Thank you. I just hope it wont get scrambled again 🙂