No, I didn't do anything at all. The server ran since months without any problems, and then suddenly this.. I just found something that may be related: A program started writing errors to a log file saying it couldn't insert into one of the tables that is now missing and the log file grew up to 2 GB. Certainly the mysql problem occured before the disk was full, else the log couldn't have been written.
Could mysql delete data files if there's no more diskspace? My monitoring server says there have been 1.3GB left on the server at 18:05. At 18:01 the problem with mysql started. The log ends at 20:13, that must have been when the monitoring program shut down for a yet unknown reason, the pid file still exists. The MySQL server never stopped running. Now I have 12GB free, 2GB less compared to before the problem occured. These 2GB are the log of the monitoring program. Here's the question: who created 10GB of data and where is that data now? The 10GB pretty sure weren't the 3 missing tables - the entire database never gets bigger than 1MB. To get back running for now, is it OK to 'touch tablen.MYD' to recreate the missing files. As I said, the frm files still exist. Hope to hear from you soon. Sincerely, Daniel Geske -----Original Message----- From: Jerry [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 10:25 AM To: Daniel Geske; [EMAIL PROTECTED] Subject: Re: problem: Loosing .MYD Files 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
