Re: Data corruption following a power failure.

2004-02-13 Thread James Moe
Andrew Iles wrote: Is this the true behavior or does it just appear to work this way? And if so, is there any way to force MySQL to automatically save data to disk in a way that is chronologically correct? This would make it much easier for me to recover from an unexpected crash. What os/vers

Data corruption following a power failure.

2004-02-13 Thread Andrew Iles
Hi. I've noticed that when a server running MySQL crashes and comes back to life, the MyISAM tables typically need to be repaired to account for the fact that they were not flushed when the server went down. However, I've also noticed that when the database is recovered from a crash, the tables