>From: "Ed Carp" <erc@stripped>
>
>> is it a normal behaviour that a sql databases gets corrupted if
>> the power of
>> the whole system will be switched off while an application is
>> writing to the
>> database ?
>
>Yes.
>
>> what can i do that this problem does no more appear ?
>
>Buy a UPS or shutdown the system normally. NEVER just turn off power to a
>computer.
And note that this is NOT a MySQL problem! If the power goes off while ANY program is
writing to disk, you are likely to have (at best) a corrupted file, and possibly a
corrupted file system as well!
If you turn off the power while writing a Microsoft Word file (for example), you will also
have a corrupted file.
What sets MySQL apart is that there is generally more at stake than there is with a single
Word file.
Small UPS systems are quite inexpensive these days. Even office-sized systems that will
protect numerous computers cost no more than a single new computer. (And they last
longer!)
Anyone doing anything that is mission-critical for any business of any size should have a
UPS capable of keeping the system up long enough to shut it down gracefully.
--
---- SQL SQL SQL SQL SQL SQL SQL SQL ----
: Jan Steinman -- nature Transography(TM): <http://www.Bytesmiths.com>
: Bytesmiths -- artists' services: <http://www.Bytesmiths.com/Services>
: Buy My Step Van! <http://www.Bytesmiths.com/van>
