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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php