From: Jan Steinman Date: October 28 2002 6:17pm Subject: RE: database corrupted after power switched off List-Archive: http://lists.mysql.com/mysql/123387 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >From: "Ed Carp" > >> 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): : Bytesmiths -- artists' services: : Buy My Step Van!