up vote 1 down vote favorite
share [g+] share [fb]

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 ?

link|improve this question
62% accept rate
why close my problem ? – Hooligan Jun 23 '10 at 9:36
@MemoryLeak: the vote has "belongs on serverfault.com" as the reason and I tend to agree. – Joachim Sauer Jun 23 '10 at 11:00
feedback

migrated from stackoverflow.com Jun 23 '10 at 17:37

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

closed as exact duplicate by splattne♦ Jun 23 '10 at 18:18

This question covers exactly the same ground as earlier questions on this topic; its answers may be merged with another identical question. See the FAQ for guidance on how to improve it.

1 Answer

up vote 0 down vote

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?

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

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