Occasionally, I'll get an MYI error in MySQL for a couple of websites I operate. It says that it cannot open the MYI file.<br /><br />I know that to fix this I Have to go to Repair Table in phpMyAdmin, but sometimes I'll lose a table row that way: That sucks if you've got all-important information in a table!<br /><br />I was wondering how this happens and what you can do to avert it.<!--content-->
I was just about to send a help desk ticket about this. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> This has happened to me three times, all on the same forum, but always to a different table. The latest time it happened was around 2am this morning from what I can tell.<br /><br />The only time I was doing anything with the forum was when I was changing some permission settings and adding a new board. I ended up having to repair the forums table and lost my main board plus the new one I had created. I was able to just add the entry back to that table to get my boards back, but still.<br /><br />Do you have any mods or anything on your forum?? I have a couple of minor mods on mine that add ibf codes and such, but I can't imagine how they would cause this.<!--content-->
Actually, the most recent time this happened to me was in a new browser-based game I'm building... Nothing in my game is built upon forums except for the Forums (phpBB), but the MYI error happened on a table I built myself...<!--content-->
Oh yeah? Mine has only happened on my invision forums (and only on one site, my other two are fine, even though one of them has much greater traffic), and are always with one of invision's default tables.<br /><br />What server are you on? Maybe it's a server issue? I'm on Server35. (but I think I used to be on Server33, so that's probably not it)<!--content-->
Multiple servers for me...<!--content-->
I was just about to send a help desk ticket about this. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /> This has happened to me three times, all on the same forum, but always to a different table. The latest time it happened was around 2am this morning from what I can tell.<br /><br />The only time I was doing anything with the forum was when I was changing some permission settings and adding a new board. I ended up having to repair the forums table and lost my main board plus the new one I had created. I was able to just add the entry back to that table to get my boards back, but still.<br /><br />Do you have any mods or anything on your forum?? I have a couple of minor mods on mine that add ibf codes and such, but I can't imagine how they would cause this.<!--content-->Actually, the most recent time this happened to me was in a new browser-based game I'm building... Nothing in my game is built upon forums except for the Forums (phpBB), but the MYI error happened on a table I built myself...<!--content-->
Oh yeah? Mine has only happened on my invision forums (and only on one site, my other two are fine, even though one of them has much greater traffic), and are always with one of invision's default tables.<br /><br />What server are you on? Maybe it's a server issue? I'm on Server35. (but I think I used to be on Server33, so that's probably not it)<!--content-->
Multiple servers for me...<!--content-->