Sometimes I install an extension that creates a new MySQL table, but it breaks because I have binary ("advanced") logging enabled. CiviCRM tries to write to the binary log, and it fails because the table doesn't exist.
Other times, there's a corrupt binary log table, which I can only fix by dropping it.
In these situations, I know that disabling and re-enabling binary logging will fix the situation, but then I lose my existing logs! Is there another less destructive solution?