Harddrive bit-rot does happen. Does MySQL go about making sure that bit-rot does not happen to my data stored in the database? Ie. does it make any row-level checksumming, or table-level checksumming? I guess it's not dealing with error correcting codes.
Let's stick to InnoDB and MyISAM for this answer (as they are the most common DB engines).