mysql crashed and created huge .MYI files. All data lost? :-((

From: Date: Sun, 19 May 2002 17:27:54 +0000
Subject: mysql crashed and created huge .MYI files. All data lost? :-((
Groups: php.db 
Request: Send a blank email to php-db+get-19262@lists.php.net to get a copy of this message
Hi there, during a wrong select statement on a table containing over 2 mill. records (involving other tables) mysql and the whole linux server crashed. After rebooting I did run myisamchk and this reported that some tables are damaged but still can be read. So I did shut down the server und run myisamchk --recover --quick *.MYI Right now mysql is recovering a table named #sql-98a_1b.MYI which I do not know where it comes from. I did definatelly not create this table. Recovery is in process now for more than 30 minutes on this table and it is counting a valueup (right now 150000) Does anybody know what happened here? I hope I do not need to role out my backup tapes :-( Thanx for any help, Andy

« previous php.db (#19262) next »