Migration errors
Fix: pgloader "fell through ECASE expression" on MySQL 8
ERROR mysql: 76 fell through ECASE expression / 255 fell through ECASE expressionWhen it happens
Running pgloader from Debian/Ubuntu packages against MySQL 8.x.
Why it happens
The pgloader binary shipped by Debian/Ubuntu bundles an old MySQL driver (qmynd) that doesn't know the collation ids MySQL 8 introduced (255 = utf8mb4_0900_ai_ci, 76 = utf8mb3_tolower_ci…).
How to fix it
1. Build pgloader from source (has the updated driver)
git clone https://github.com/dimitri/pgloader.git
cd pgloader && make pgloader
./build/bin/pgloader --version2. Or use our hosted converter
We compile pgloader from upstream source exactly for this reason — upload your dump and skip the toolchain fight.
Migrating between MySQL and PostgreSQL?
Our converter handles this and dozens of other gotchas automatically — upload a dump, download working SQL.
Try the converter free