List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:October 28 2002 6:17pm
Subject:RE: database corrupted after power switched off
View as plain text  
>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>
Thread
database corrupted after power switched offTom Thurnherr28 Oct
  • RE: database corrupted after power switched offEd Carp28 Oct
  • re: database corrupted after power switched offVictoria Reznichenko28 Oct
re: database corrupted after power switched offBill Easton28 Oct
  • Re: database corrupted after power switched offMichael T. Babcock28 Oct
  • Re: database corrupted after power switched offMark28 Oct
  • Re: database corrupted after power switched offBill Easton28 Oct
  • Re: database corrupted after power switched offMichael T. Babcock28 Oct
RE: database corrupted after power switched offJan Steinman28 Oct