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