#MySQL

FOREIGN_KEY_CHECKS Didn't Work When Running mysqldump SQL via PHP PDO

A migration failure caused by relying on mysqldump's conditional comments, and how to fix it.

Multibyte Characters Get Corrupted When Inserting into Docker MySQL via PowerShell

Japanese text gets mangled when inserting into MySQL on Docker from PowerShell. PHP-based insertion works fine, suggesting the issue is PowerShell's character encoding, not the application.

Every Date Was Wrong: Server, MySQL, PHP, and JavaScript All at Once

A story about dates going haywire in an AI-generated PHP script, plus a breakdown of timezone pitfalls in each layer — server, PHP, MySQL, and JavaScript.