hello.
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 ?
what can i do that this problem does no more appear ?
thanx
tom
---
bbv Software Services
Tom
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
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
VRDate: Mon, 28 Oct 2002 12:35:01 +0200
VRFrom: Victoria Reznichenko [EMAIL PROTECTED]
VRSubject: re: database corrupted after power switched off
VRTom,
VRMonday, October 28, 2002, 11:59:16 AM, you wrote:
VRTT is it a normal behaviour that a sql databases gets corrupted if the
power of
VRTT
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
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 corrupted after power switched off
Again, make sure you check how your OS
]
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:
... which says MyISAM table format is very reliable (all changes to a
table is written
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
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