can copying them
to back up. This way you just have to lock db and copy back!
Simon
- Original Message -
From: "Kelvin Leung" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 18, 2004 3:23 AM
Subject: Data lost
> My client reported the a
My client reported the a case to me. He said one mysql table lost some of
the data. The table structure is shown as follows:
+---+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+-
t; <[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 who
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
myis