database

Broken characters in a mysqldump usually mean the connection charset is wrong, not just the file output. This guide shows how to verify schema and column charsets, export safely, and avoid bad handoffs during migrations or client work.

Legacy MySQL imports often fail because newer defaults reject zero dates. This guide shows how to inspect `sql_mode`, find affected columns, use a safer session-level workaround, and decide when to fix the schema instead.