>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
Mark wrote:
Again, make sure you check how your OS deals with >> write caching <<
and consider turning it off on the partition / disk you're using for
DB storage.
I would certainly not do that. In fact, disk caches (for non 4.04 users) are
an excellent, be it a poor man's, way of having a
k" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Tom Thurnherr" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 10:18 AM
Subject: Re: database corrupted after power switched off
> Bill Easton wrote:
>
&
Original Message -
From: "Michael T. Babcock" <[EMAIL PROTECTED]>
To: "Bill Easton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Tom Thurnherr" <[EMAIL PROTECTED]>
Sent: Monday, October 28, 2002 4:18 PM
Subject: Re: database corru
Bill Easton wrote:
... which says "MyISAM table format is very reliable (all changes to a
table is written before the SQL statements returns)" Evidently, this is NOT true.
(Perhaps, it used to be true for ISAM tables. The documentation should be
changed.)
You are misinterpreting the stateme
VR>Date: Mon, 28 Oct 2002 12:35:01 +0200
VR>From: Victoria Reznichenko <[EMAIL PROTECTED]>
VR>Subject: re: database corrupted after power switched off
VR>Tom,
VR>Monday, October 28, 2002, 11:59:16 AM, you wrote:
VR>TT> is it a normal behaviour that a sql databases get
Tom,
Monday, October 28, 2002, 11:59:16 AM, you wrote:
TT> is it a normal behaviour that a sql databases gets corrupted if the power of
TT> the whole system will be switched off while an application is writing to the
TT> database ?
Yes. Other situations when tables may become corrupted are listed
> 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
