Every morning when I get into work, I try to do a query on one of my mysql table. I get this message.
ERROR 1017: Can't find file: 'postdata_cashier.MYD' (errno: 2)
I wrote a script to query the table every hour and send me a count of the table, so I could find out what time the table went bad. I get email up to 4:00 a.m. Come to find out We back up our tables at 4:00 a.m.
I have taken the test script out of the cron and still the MYD and MYI files are missing from /var/lib/mysql/database/
The only file that remains is postdata_cashier.frm
Can someone explain and tell me how to fix this problem.