Flecko
6-19-03, 10:08 PM
EDIT: the problem was (sort of) resolved. Fixed the table with repair, though I lost some data. What makes tables arbitrarily screw up like that?
------------------
My database was working perfectly three minutes ago, and all of a sudden, an entire table is messed up. I tried to check it with Mascon (my MySQL tool). First I only got two out of the five pieces of data that should have been in there. Then, a few seconds later when I tried again, it returned the error, "1016 - Can't open file 'forums.MYI' (errno: 145)" (forums is the name of the table). I have no clue what caused this, as it's been running fine for a few days and I was not working on the site at all. Basically, it's acting as though none of the data in the table exists. I need help as quickly as possible, this is a serious and crippling problem. Thank you.
------------------
My database was working perfectly three minutes ago, and all of a sudden, an entire table is messed up. I tried to check it with Mascon (my MySQL tool). First I only got two out of the five pieces of data that should have been in there. Then, a few seconds later when I tried again, it returned the error, "1016 - Can't open file 'forums.MYI' (errno: 145)" (forums is the name of the table). I have no clue what caused this, as it's been running fine for a few days and I was not working on the site at all. Basically, it's acting as though none of the data in the table exists. I need help as quickly as possible, this is a serious and crippling problem. Thank you.