RDS restore completed but returned ERROR 1366 incorrect string value for column — the charset/collation repair and dump/reload recovery I executed
Anyone managing Amazon RDS instances with MySQL can attest to how smooth yet unexpectedly difficult restorations can be. You’d think that restoring data from a recent backup should “just work.” But when “ERROR 1366: Incorrect string value” stared me down in the aftermath of what looked like a successful RDS restore, I realized that character set and collation mismatches could morph into full-blown recovery puzzles. Read more