I just want to briefly recognize MySQL for its resilience and robustness. Even in the event that a table gets corrupted, as happened today with the tables driving the MultimediaWiki, ‘CHECK TABLE’ and ‘REPAIR TABLE’ can diagnose and fix the problem and have your MySQL-backed application up and running in short order. Of course, I also have an automated script backing up the database tables off-site, every night, just for good measure.
I just want any current or future contributors to be secure in the knowledge that the data is safe.
As a PostgreSQL snob, I have to point out that, had you been using PostgreSQL, your data most likely would not have gotten corrupted in the first place. :-) (ducking)
Okay, so you want to start something… :)
My “Hello World” test programs never, ever have any data integrity issues either… because, like a certain database I could name, they don’t do anything useful!