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.
From: Jerry [mailto:jerry@stripped]
Sent: Wednesday, February 26, 2003 10:25 AM
To: Daniel Geske; mysql@stripped
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.
----- Original Message -----
From: "Daniel Geske" <daniel.geske@stripped>
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
> 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,
> is only one file left: the .frm file. So I'm wondering: where have the
> file and the index file gone?
> Does anybody know about any such peculiarities in mysql 3.23.44-Max,
> with SuSE 7.3 Pro?
> I checked the mysql error log as well as the system logs and found
> 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!
> 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 <mysql-thread133394@stripped>
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php