LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   MYI and MYD files getting removed (https://www.linuxquestions.org/questions/linux-newbie-8/myi-and-myd-files-getting-removed-4175425620/)

qweeak 09-04-2012 02:06 PM

MYI and MYD files getting removed
 
Hello Guys,

I got a strange problem. I got a MyISAM table whose MYI and MYD files get removed after some time. Any idea why this is. Only file that is present is frm file. Any way to recover this table from frm file

mattlezeay 09-05-2012 10:58 AM

Not sure about why they would be deleted, especially just those two of the three. the MYD is the data, the MYI is the index, the frm is just the structure, so it *could* be a TRUNCATE statement running on the table. There is no way to recover that table without having at least the MYD as far as I know since that is what holds the actual data.


All times are GMT -5. The time now is 04:02 PM.