Mysql to postgres Migration pgloader "ERROR mysql: 76 fell through ECASE expression"

Question

While I try to migrate my MySQL Databse to a Postgres database.

I Face the Following Error.

How can I solve this?

Answer 1

I solved it by compiling pgloader from source.

Answer 2

You may find the solution found by user Axxxolotl in this GitHub issue comment useful:

apt remove pgloader -y
git clone https://github.com/dimitri/pgloader.git
apt-get install sbcl unzip libsqlite3-dev make curl gawk freetds-dev libzip-dev
cd /path/to/pgloader
make pgloader
./build/bin/pgloader --help
pgloader --debug mysql://root:'123'@127.0.0.1/nextcloud_storage postgresql://postgres:pass@127.0.0.1:5432/nextcloud_storage