I feel like everyone who worked with MySQL, had some story with lost data. Two companies that I worked for used MySQL and in both of them I had an instance wher

I feel like everyone who worked with MySQL, had some story with lost data. Two companies that I worked for used MySQL and in both of them I had an instance where data was lost or corrupted and it did not involve hardware failure. First instance was that there was MySQL service that crashed and refused to start up. The machine was not rebooted or shut down abruptly, disk was not corrupted, also disk was not full and had plenty of space. Running repair command resolved the issue, but it was weird. In another instance we run into a bug and apparently certain character combination in the data made MySQL all out of sudden think the data was encrypted.