Ok, I ran xfs_check and the filesystem is all well. Does anybody else
have an idea?
Regards,
Samy
Samuel Vogel schrieb:
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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]