Why do my sites show errors when I enable InnoDB force-recovery mode in MySQL?

Question

Why do my sites show errors when I enable InnoDB force-recovery mode in MySQL?

Answer

When you enable InnoDB force-recovery mode in MySQL, all InnoDB data becomes read-only. As a result, sites are unable to write to databases that use InnoDB and so display errors.

You can find more information on InnoDB recovery in MySQL here:

InnoDB Corruption Repair Guide