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,


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to