Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
mysql data loss after server crash

After the server restarted due to a power cut, we lost all data saved in the database during the morning (client records created in the website). A few minutes before the crash, I was able to see such data on "MySQL Query Browser" during some routine checks. After the crash, all records created in the morning disappeared and the most recent ones that I could see were created at 7 p.m. the day before. It seems like all INSERT statements were performed in a cache that could not be flushed because of the power cut. Does MySQL use such caching mechanism ? If yes, is it crash proof and how can I configure it ?

share|improve this question

migrated from Jun 23 '10 at 17:37

This question came from our site for professional and enthusiast programmers.

marked as duplicate by splattne Jun 23 '10 at 18:18

This question was marked as an exact duplicate of an existing question.

Have you tried repairing the affected tables?

I've never lost data on that scale in MySQL: it seems to write to disk immediately. Maybe MySQL isn't the culprit here - maybe CHKDSK did that to you, or maybe you have some auto-filesystem rollback in place?

share|improve this answer
I don't know, I use ubuntu with hardware raid. – Hooligan Jun 23 '10 at 15:13

Not the answer you're looking for? Browse other questions tagged or ask your own question.