Use a backup powersupply and shutdown software to gracefully shutdown
after a power fail.
Yaw Ofori-Adjei wrote:
> I have used MySQL for about 2 years nowand I love it.
> My only problem is that I am in africa were power
> fluctuations are rampant. I usally get table handelr
> error 127 after ev
Hello.
Have a look at the transaction safe table types (InnoDB, BDB, ...). I
did not try them myself, but from what I read on the list, there is a
good chance that they will return to a consistent state themselves.
Bye,
Philemon.
PS: Of course, the better solution would be a back-up p
> It there a way around this error occuring
> after every outage?.
Eeek!
Are you running myisamchk -r? - obviously, there isn't really much of a
way to avoid having to repair tables after a hard OS crash. I would
highly recommend trying to get ahold of something like an APC battery
supply whic