WordPress Site Health can flag bloated autoloaded options, but safe fixes depend on tracing oversized or stale data, save logic, and request-path impact.
Broken characters in a mysqldump usually mean a charset mismatch. Verify metadata, dump with the right setting, and test imports before migration handoff.
Legacy MySQL dumps can fail on zero dates. Learn how to inspect sql_mode, audit affected columns, use a session-only import bridge, and plan the cleanup.