Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com 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 has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

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.