>From: "Ed Carp" <[EMAIL PROTECTED]> > >> 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> --------------------------------------------------------------------- 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
