Have you done anything to the files by hand ? I used to get this when I moved tables about and effected the permissions or case of the extensions.
Jerry ----- Original Message ----- From: "Daniel Geske" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 9:13 AM Subject: problem: Loosing .MYD Files > Hi all, > > Today I ran into a weird problem. > Normally, for each database there is one directory on the hard drive. > For every table, there are three files (.frm, .MYD, and .MYI). Now I want to > access the db and everything goes well. Trying to access certain tables > results in this error: > > Error 1017 - Can't find file: 'tablen.MYD' (errno: 2) > > Checking the filesystem I discover that for all the 13 tables in that > database there are three files (.frm,.myd,.myi) but for three tables, there > is only one file left: the .frm file. So I'm wondering: where have the data > file and the index file gone? > > Does anybody know about any such peculiarities in mysql 3.23.44-Max, shipped > with SuSE 7.3 Pro? > > I checked the mysql error log as well as the system logs and found nothing. > No errors - the files are just gone. > > I'd be happy to hear from anybody who may have an idea what's going on. > Thank you! > > Sincerely > > Daniel Geske > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php