mysql crashed and created huge .MYI files. All data lost? :-((
| From: | andy | 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