Hey,

Thanks for the very fast reply.
Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45
from backports.

We have a 20GB quota set for MySQL. Before the crash about 9GB where
used, now it's down to 5GB. I will unmount the disk and check the XFS
filesystem and report back here!

Regards,
Samy

Michael Dykman schrieb:
> What system are you on? What is your disk capacity? It looks like
> the disk got corrupted.. How *that* happened is hard to say, but
> know what host OS/hardware you are on would give us a first clue.
>
> - michael
>
>
> On Dec 6, 2007 2:42 PM, Samuel Vogel <samy-delux@gmx.de> wrote:
>
>> Hey guys,
>>
>> I have a big Problem. About 30 % of my databases just disappeared around
>> 6pm today. I do not have any clue how this happened. Is can just guess
>> the time it happened from my munin graphs.
>>
>> The only thing that might be a clue are the following files in my data
>> directory:
>> h1314631:~# ll /data/mysql/#sql_1a03_3.MY*
>> -rw-rw---- 1 mysql mysql 0 2007-10-10 21:20
>> /data/mysql/#sql_1a03_3.MYD
>> -rw-rw---- 1 mysql mysql 1,0K 2007-10-10 21:20
>> /data/mysql/#sql_1a03_3.MYI
>> h1314631:~# cat /data/mysql/#sql_1a03_3.MYI
>> %?????????????????????????????G
>>
>>
>> ??e ?eA????
>> ??e
>>
>> 3e
>>
>> The date does not match, but I'm wondering where they come from anyways.
>> There are about 1200 of them with about 5000 databases left, from 7500!
>>
>> Where could I get a clue about what happened?
>>
>> Regards,
>> Samy
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com
>>
>>
>>
>
>
>
>