Andy,
I believe that that file is an on disk temporary file that was created
during the query. I would suggest you wait for the recover to finish as I
think (hope) your data will be returned to a fairly normal state when it
does.
Ric.
----- Original Message -----
From: "andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 19, 2002 6:28 PM
Subject: mysql crashed and created huge .MYI files. All data lost?
> Hi there,
>
> during a wrong select query 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
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
